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 “clupeid” 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.

130 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
clupeid123463(None) 
clupeids1343241clupeids
clupeoid1343641clupeoid
cleped115114112clepe_d
clued84917682clu_e_d
clumped143610662clumpe_d
clupeoids1442582clupeoids
clypei1334162clypei_
couped115019312coupe_d
cupid103212782c_up_id
aliped95414283alipe_d
blued84520323blu_e_d
blumed114313643blume_d
camped134720233campe_d
caped104931803c_ape_d
capped134721853cappe_d
capsid11312413c_apsid
carped115923763carpe_d
caused95117043cause_d
cepheid1545433cepheid
chumped17379493chumpe_d
chuted124611843chute_d
clamped144012043clampe_d
clapped143511173clapped
clasped123610443claspe_d
clawed125115073clawe_d
clayed125013043claye_d
clepe94617383clepe__
clepes104214623clepe_s
clerid9312413cl_erid
clewed1225113203clewe_d
clipped14439833clipped
clomped14398973clompe_d
cloned94518803clone_d
clopped143611523clopped
closed95317963close_d
clouded11348833cloude_d
cloured103111543cloure_d
clouted104212163cloute_d
cloyed125111563cloye_d
clubbed14307453clubbed
clubhead1662773clubhead
clucked163810133clucked
clue65324533clu_e__
clueing104110093clu_eing
clues74623033clu_e_s
clumpier1435583clumpier
clunked14439573clunked
clypeal1443513clypeal
clypeus1433243clypeus
colubrid1344413colubrid
comped135919873compe_d
compend144010303compend
cooped114821603coope_d
coped105036843c_ope_d
copied114618563c_opied
copped135221253coppe_d
coupe96023483coupe__
coupes105022523coupe_s
coupled124312673coupled
craped116120523crape_d
creped114115703crepe_d
crumped144311223crumpe_d
cubed105519703c_ube_d
cuboid1139503c_uboid
cued76329563c_u_e_d
culicid1247383culicid
culled94022473culle_d
cullied104012353cullied
culmed114610593culme_d
culprit1147863culprit
cupel9514303c_upe_l
cupeled1257793c_upeled
cupels10310203c_upels
cupids11369193c_up_ids
cupped134413983c_upped
cupric1249123c_upric
cured85932133c_ure_d
cusped114312043cuspe_d
cuspid11429213c_uspid
duped95118323_dupe_d
elapid939543elap_id
eloped95914143elope_d
eluded84612773elude_d
eluted74915263elute_d
flued95021253flu_e_d
fluid94013963flu__id
fluked145112093fluke_d
flumed124915263flume_d
flumped15377713flumpe_d
fluorid1136783fluorid
fluted104917163flute_d
fluxed17509673fluxe_d
glued75118363glu_e_d
glutei7409743glutei_
gulped104610373gulpe_d
jauped16457903jaupe_d
kluged12427233kluge_d
lipid85916173_lip_id
lipoid9411043_lipoid
loped85128333_lope_d
louped95316383loupe_d
lubed85319893_lube_d
lucid84314573_lu_cid
luged74019093_luge_d
lumped114216963_lumpe_d
lupin75215843_lup_in
lured65427493_lure_d
lurid64618973_lu_rid
luted64826143_lute_d
lutein6311263_lutein
occupied1542943occupied
plumed114412883plume_d
plumped14318643plumpe_d
plutei8408903plutei_
pulped114612533pulpe_d
rouped95717353roupe_d
sclereid1145363sclereid
sculped12398253sculpe_d
sliped95417063slipe_d
sloped94216853slope_d
slued64220513slu_e_d
slumped123710153slumpe_d
slurped10368753slurpe_d
souped95017673soupe_d
stupid937593stup_id
sulphid1346113sulphid
upend85011043__upend
yauped12408333yaupe_d
ycleped1543393yclepe_d

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 Limit1340271307.00319138.5
3Display Results1301300.0462826.1
 (SQL Overall)1786911307.45223978.9
 
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.