Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “lattice” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

228 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
lattice93843(None) 
latticed1134791latticed
lattices1038381lattices
attic75618352_attic_
attics84413282_attics
attire62412382_attire
brattice1245692brattice
cattie85221022catti_e
lactic10713492lactic_
latices9313762la_tices
latrine7715122latrine
latte55426302latt__e
lattin64316222latti_n
lattins74115482lattins
lettuce943322lettuce
pattie84020962patti_e
statice92614032statice
tattie64817512tatti_e
active11313743_active
advice12107883_advice
amice96122873_a_mice
antic75728863_antic_
antick124814583_antick
antics84621453_antics
article9310923_article
attach11118393_attach
attache12106693_attache
attack12148153_attack
atticize1948443_atticize
attired8238913_attired
attires72312953_attires
attrite7311833_attrite
attune637983_attune
baptise1139553baptise
baptize2036983baptize
bastile9313913bastile
batlike133311883batlike
battier93515713battier
battik1238093batti_k
battiks1337143battiks
batting104422273batting
battle85217863batt_le
battue84311003batt_ue
bawtie113812143bawti_e
blastie92411393blasti_e
blatting114111653blatting
bratticed1443283bratticed
brattices1345553brattices
caddice13327733caddice
cantic103920543cantic_
canticle1239703canticle
caprice1349683caprice
captive1438973captive
catface1436763catface
catlike132712933catlike
cattier93317073cattier
catties94023053catties
cattily123210853cattily
catting103922643catting
cattish12410723cattish
cattle85118903catt_le
clastic113013963clastic_
clastics122811413clastics
dative10311813da_tive
dautie72914703dauti_e
dawtie103011093dawti_e
daytime1344783daytime
elastic93013393elastic_
elastics102710883elastics
elative10312453ela_tive
entice81316863_entice
fatlike142911193fatlike
fattier103513463fattier
fatties103018203fatties
fattily13379463fattily
fatting113818703fatting
fattish1359263fattish
flatline11298923flatline
flatting123511253flatting
flattish1455263flattish
flatwise1443973flatwise
glottic1036653glottic_
haptic13511893haptic_
hatlike143311713hatlike
hatting113920233hatting
hottie92514383hotti_e
iatric8312163iatric_
justice1637423justice
labile8315223la_bile
lace66848473la___ce
lactase937953lactase
lactate9312693lactate
lactone9311393lactone
lactose969473lactose
laddie83713173laddi_e
laetrile845193laetrile
laic65931563la__ic_
laich105920713la__ich
laicise939333laicise
laicize1838093laicize
laics76419253la__ics
laitance1045973laitance
laities7320343laities
lambie103213673lambi_e
lamiae84817453la_miae
lance75126723la__nce
larine63927043la_rine
lassie64917743lassi_e
lasting84725243lasting
latch104620463la_t_ch
late47560483la_t__e
latency1236033latency
laterite8716333laterite
laterize17613293laterize
lathe85626713la_t_he
lathi85417203lathi__
lathier10310833lathier
lathing114315693lathing
lathis95516173lathi_s
lati46438273la_ti__
latigo73410013la_tigo
latina65621143la_tina
latinize17610563latinize
latino64120473la_tino
latish92416173la_tish
latitude9185513latitude
latke94817093la_t_ke
latria62313593latri_a
latrias71913213latrias
latrines8515003latrines
latten65018203latt_en
lattens75014673lattens
latter65027893latt_er
lattes65324203latt_es
latticing1246063latticing
launce8469183la_unce
lauwine1036373lauwine
lawine93316463la_wine
lawlike14137073lawlike
laxative1845093laxative
lentic83515743lentic_
lenticel1066123lenticel
letting83218533letting
lettuces1043503lettuces
lice66045063l___ice
lithic1139493lithic_
litotic939243litotic_
little63312163litt_le
lotic76420673l_otic_
lotte54923853lott__e
lotting82917753lotting
luetic8310383luetic_
luetics937323luetics
lytic104513033l_ytic_
lyttae994713lytt_ae
malice104818483ma_lice
mantic104120903mantic_
mastic103119173mastic_
mastiche1547173mastiche
mastics112614783mastics
matrices12312083matrices
matte75626843matt__e
mattin84416633matti_n
matting103620143matting
mattins93316143mattins
mattock1535823mattock
mortice11711493mortice
nastic82915973nastic_
native9613013na_tive
nattier73614623nattier
nattily103610323nattily
notice8313443_notice
oatlike113412403oatlike
pantie84326473panti_e
pantile93918483pantile
particle1239533particle
partite9317133partite
pastiche1546933pastiche
pastie85525523pasti_e
pastime114611973pastime
patine85328123pa_tine
pattee84323383patt_ee
patties93425143patties
patting103722343patting
plaice10311553pla__ice
plastic112815063plastic_
plastics122412333plastics
platting114813033platting
playtime1544793playtime
practice1438733practice
puttie84116303putti_e
ragtime1036163ragtime
ratine65131823ra_tine
ratite65022423ra_tite
ratlike113912353ratlike
ratline74517803ratline
rattier74015593rattier
ratting83822363ratting
rattish10510823rattish
rattle64717613ratt_le
saice75424053sa__ice
saltie63422433salti_e
saltine75018563saltine
saltire73113033saltire
satire63218003sa_tire
slatting94014233slatting
static83118683static_
statices102712343statices
statics93314533statics
stative102612933stative
tactic10612753tactic_
tactics1149323tactics
tactile9310613tactile
tattier74216243tattier
tatties74120343tatties
tattily10409993tattily
tatting84019523tatting
tattle64115653tatt_le
titmice1144663titmice
tittie63213153titti_e
trice75127493__trice
twice104711123__twice
vatic10316423va_tic_
vatting113614853vatting
wartime1237743wartime
wattage1186983wattage
wattape12135383wattape
wattle94314213watt_le

Search took 8 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911340270.403443402.0
2DLD Change Limit1340272287.45617975.7
3Display Results2282280.0932451.6
 (SQL Overall)1786912287.95222471.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.