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

114 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
clover11461712(None) 
claver113816971claver
clever114611531clever
cloner84418091cloner
closer84918201closer
clove105619441clove_
cloven114211511cloven
clovers125114661clovers
clovery15407401clovery
cloves114918821cloves
cover105430771c_over
glover104513531glover
lover85526451_lover
plover115312611plover
allover1038582allover
blower115316572blower
caloyer1238142caloyer
carver114420152carver
caver105629062c_aver
choker154314372choker
choler113717152choler
clave105420152clave_
clavers124314902clavers
claves115020062claves
clavier1239172clavier
clawer114512782clawer
cleaver124110802cleaver
clivers123411752clivers
clobber13378162clobber
clocker153910872clocker
clogger11438802clogger
clone75728162clone_
cloned94518802cloned
cloners94514822cloners
clones84526562clones
close76425222close_
closed95317962closed
closers94415322closers
closes85425592closes
closet85226602closet
clour76617282clo_ur
clouter93511692clouter
clovered14187362clovered
clowder13367942clowder
cloyed125111562cloyed
cloze165517542cloze_
clozes174915562clozes
coder86134222c_oder
colder95121852colder
colorer9312522colorer
colter84625092colter
comer95832692c_omer
cooer74831012c_ooer
cooker124722452cooker
cooler84824712cooler
cooper104221122cooper
cooter85128612cooter
coper95336092c_oper
corer75538872c_orer
cove95837072c_ove_
coved115027372c_oved
coven106925042c_oven
covers114627962c_overs
covert114925502c_overt
coves105539172c_oves
covet105638942c_ovet
covey136121782c_ovey
cower104531772c_ower
coyer105222842c_oyer
craver114618472craver
crower114117562crower
crozer175112842crozer
culver113010632culver
cutover1235282cutover
drover104614592drover
eloper85414152eloper
elver85216242el_ver
flower124815502flower
flyover1633512flyover
glove94516292glove_
gloved114811872gloved
glovers114310882glovers
gloves104115182gloves
glower105114932glower
hoover124314432hoover
hover115524132_hover
laver85031792_laver
lever85125162_lever
liver85132962_liver
loner55431042_loner
loper75129232_loper
loser54728672_loser
louver94110392_louver
love75234762_love_
loved95021362_loved
lovers94223432_lovers
loves85332012_loves
lower85830412_lower
mover104220862_mover
over77227342__over
plovers123611832plovers
plower114315062plower
prover113819722prover
rover85527372_rover
shover124515992shover
slaver94419612slaver
sliver94116592sliver
sloper84615912sloper
sloven9389632sloven
slower94016152slower
solver94016702solver
stover94115642stover
trover95014662trover
wolver12419712wolver

Search took 3 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 Filter178691825510.330541487.9
2DLD Change Limit825511142.29635954.3
3Display Results1141140.0462478.3
 (SQL Overall)1786911142.67266875.4
 
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.