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

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

97 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
culicid124738(None) 
culicids1345621culicids
colicin11313742colicin
culices113713122culices
culicine1248342culicine
pulicide1347042pulicide
alcid85817973_al_cid
allicin949953allicin
aulic74420243aulic__
bulimia1145043bulimia
bulimic1345143bulimic
calcic9311873cal_cic
calices114321693calices
caliche14329963caliche
calicle113111433calicle
calico103414433calic_o
calicos113913493calicos
caulicle1245043caulicle
chalcid1537883chalcid
chaliced1637043chaliced
chlorid133211843chlorid
cilice103213353cilic_e
cilices113814023cilices
clerid9312413c_lerid
cliche133712453c_liche
cliched153711023c_liched
click135217953c_lic_k
clicked164112453c_licked
clicks145315113c_licks
clinic104312793c_linic
clitic103315053c_litic
clivia1177233c_livia
clupeid1234633clupeid
coccid102910743c_occid
codicil1246813codicil
colic95726173colic__
colicine12312993colicine
colicins12312853colicins
colicky1835783colicky
colics104219903colic_s
colitic112916193colitic
colitis92617353colitis
colloid10312883colloid
cricoid1239243c_ricoid
cubic114313423cubic__
cubical1338463cubical
cubicity1746033cubicity
cubicle1337003cubicle
cubicly1644993cubicly
cubics123810163cubic_s
cubiti10399083cubiti_
cuboid1139503cu_boid
culch124512833cul_c_h
culicines1347013culicines
culled94022473cul_led
cullied104012353cullied
cullis84115993cul_lis
culmed114610593cul_med
culprit1147863culprit
cultch13385953cultc_h
culti76317253cul_ti_
cultic105111903cul_tic
cupid103212783cu__pid
curlicue1243223curlicue
curlicued1442133curlicued
cuspid11429213cu_spid
cuticle1138233cuticle
cylices14359283cylices
elicit8417203_elicit
filicide1446363filicide
fulgid1137043ful_gid
helicoid1446753helicoid
illicit949833illicit
juiced1636513ju_iced
licit74327683__licit
lipid85916173__lipid
livid96714423__livid
lucid84314573__lucid
mucid104115253mu__cid
multifid1445833multifid
muscid11219833mu_scid
placid114012543_placid
policed123212233policed
pulicides1446283pulicides
pumiced1435173pumiced
salicin9311223salicin
silicic1147603silicic
silicide1147833silicide
sliced94416313_sliced
sluiced1046053sluiced
solicit9315743solicit
spliced124310593spliced
subacid1248473subacid
suicide1038893su_icide
sulci7615053sul_ci_
sulfid1039063sul_fid
sulphid1346113sulphid

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.406440125.6
2DLD Change Limit134027977.04619021.7
3Display Results97970.0462108.7
 (SQL Overall)178691977.49823831.8
 
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.