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 “ilia” with Change Limit: [1] [2]

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

105 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
ilia4602682(None) 
cilia73016761cilia
glia56423151glia
ilea45931461ilea
iliac75013491iliac
iliad64613461iliad
ilial55317841ilial
ilka87215151ilka
inia45024701inia
ixia115713211ixia
milia72719571milia
ala312463602al_a
alba68328332alba
alfa77624272alfa
alga57927602alga
alias55834602alias
alif76242142alif
alit46155692alit
aliya83713482aliya
alma66333022alma
amia66836902amia
aria46245422aria
blin67228172blin
blip88322772blip
chia96026622chia
clip86924002clip
dulia61014982dulia
fila74729132fil_a
filial93013252filial
flea75628492flea
flic96223732flic
flip96324262flip
flir76422202flir
flit76539272flit
folia83618932folia
glial66715432glial
glias64618492glias
glib79421442glib
glim76026352glim
hila76228352hil_a
hili75626632hili_
ibis66519582ibis
idea59122772idea
ileac75814172ileac
ileal56118082ileal
ilex115822032ilex
iliads7448672iliads
ilium74614182ilium
ilk78325302il_k
ilks87218572ilks
ill37437092il_l
ills47030422ills
illy76925332illy
imid76122292imid
iota45127832iota
irid55927172irid
iris45732552iris
isba61310882isba
iwis77117012iwis
ixias12488372ixias
kilim11711892kilim
klik74412652klik
la219261632_l_a
lea37660182_lea
li29948752_li_
liar47229682_liar
lib57750272_lib
lid47453522_lid
lie38264522_lie
lima65734132lima
lin37967372_lin
lip514755802_lip
lipa68425922lipa
lira46928682lira
lis37162272_lis
lit39377312_lit
milpa92111402milpa
obia67923112obia
ohia75719362ohia
oidia6314952oidia
olea46532722olea
olio46829672olio
olla44821172olla
pia56848032_pia
pilea75123952pilea
pili66130352pili_
pilis75825202pilis
plea66830602plea
plica9613372plica
plie65127392plie
raia46638382raia
ria36745502_ria
silica8311242silica
silva82714022silva
slid55828982slid
slim66631962slim
slip67031732slip
slit46250102slit
telia55821142telia
tibia7312402tibia
ulna46317332ulna
ulva75412692ulva
via65636242_via
vigia94813272vigia
villa85321232villa

Search took 2 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 Filter178691298720.263679433.5
2DLD Change Limit298721050.87634100.5
3Display Results1051050.0303500.0
 (SQL Overall)1786911051.169152858.0
 
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.