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

108 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
creels8441694(None) 
creeds94714771creeds
creeks124812921creeks
creel75121481creel_
creeps104213621creeps
crenels93711011crenels
crewels12438491crewels
reels55333261_reels
ariels65119372ariels
artels66216232artels
breeds94914882breeds
breeks125310792breeks
brees75632552bree_s
camels105217082camels
carcels114516062carcels
careens94514702careens
careers95218782careers
carpels115315462carpels
carrels95117302carrels
cartels94618122cartels
carvels124914592carvels
cees65941592c_ee_s
ceils75019402c_eils
cells75428062c_ells
cels65534972c__els
cereals9313172cereals
ceres75540012cere_s
cereus85215522cereus
cheeks154712782cheeks
cheeps135312912cheeps
cheers114518912cheers
chiels115115932chiels
cleeks125010542cleeks
corbels113813592corbels
cormels113813372cormels
cornels94716662cornels
craals84113302craals
crawls114712082crawls
creaks124315962creaks
creams104715252creams
credos94612852credos
creds85418772cr_eds
creed85727392cree_d
creek114917392cree_k
creeled104012012creeled
creep95218102cree_p
creepy13418802creepy
creese84014332creese
creeses93914622creeses
creesh11328332creesh
cremes104517992cremes
crenel84213062crenel_
creole8913732creole
creoles9913322creoles
crepes105419342crepes
cresols939652cresols
cress75022832cr_ess
crests85218702crests
cresyls1234752cresyls
crewel114310482crewel_
crews105917502cr_ews
criers83918582criers
cries75438402crie_s
cruel74815902cruel_
cruets85314952cruets
cupels10310202cupels
drees65628522dree_s
eels46536742__eels
feels85223042_feels
freely12310962freely
freers94717302freers
frees86131392free_s
greeds84314282greeds
greens75716872greens
grees65132472gree_s
greets75117422greets
gruels73910152gruels
heels85625532_heels
keels94622412_keels
kneels10408932kneels
kreeps12427412kreeps
oriels64914622oriels
peels75226422_peels
preens85020112preens
prees75937172pree_s
reals55038652_reals
rebels84518132_rebels
reeds65430902_reeds
reefs85121662_reefs
reeks94124032_reeks
reel45240532_reel_
rees45364192_ree_s
refels94618052_refels
repels84318762_repels
revels94220572_revels
riels55121332_riels
screeds106210292screeds
screens95212182screens
screes85023972scree_s
seels55632822_seels
speels85116392speels
steels64117982steels
streels73811342streels
teels55726372_teels
treens65317872treens
trees55835762tree_s
unreels7258312unreels
wheels123811712wheels

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.343520965.0
2DLD Change Limit825511082.50033020.4
3Display Results1081080.0303600.0
 (SQL Overall)1786911082.87362196.7
 
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.