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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

61 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
cilia7301676(None) 
ilia46026821_ilia
milia72719571milia
calif104929102calif
calix145317352calix
calla74827072calla
ceili75814792ceili_
ceilis85413742ceilis
celiac101910432celiac
cella75420312cella
ceria75125352ceria
chia96026622c_hia
chili106218482chili_
chiliad1337562chiliad
chilis115517872chilis
ciliary1247922ciliary
ciliate9514602ciliate
cilice103213352cilice
cilium104311372cilium
circa9311402circa
civic123412542civic
civie103716352civie
civil103411932civil
clip86924002c_lip
clivia1177232clivia
cobia94117512cobia
cola66541392col_a
colic95726172colic
colin76231692colin
colza165112982colza
coria75828322coria
culpa93610962culpa
curia74523772curia
cylix17448622cylix
dulia61014982dulia
fila74729132fil_a
filial93013252filial
folia83618932folia
glia56423152_glia
hila76228352hil_a
hili75626632hili_
ilea45931462_ilea
iliac75013492_iliac
iliad64613462_iliad
ilial55317842_ilial
ilka87215152_ilka
inia45024702_inia
ixia115713212_ixia
kilim11711892kilim
milpa92111402milpa
oidia6314952oidia
pilea75123952pilea
pili66130352pili_
pilis75825202pilis
scilla8310942scilla
silica8311242silica
silva82714022silva
telia55821142telia
tibia7312402tibia
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 Filter178691538000.343520965.0
2DLD Change Limit53800611.61033416.1
3Display Results61610.0163812.5
 (SQL Overall)178691611.96990752.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.