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 “created” 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
created10432345(None) 
cerated103922471cerated
cheated134416341cheated
cleated103417841cleated
crated94827771cr_ated
creaked143413231creaked
creamed123913711creamed
creased104315581creased
create85126381create_
creates95225201creates
cremated133412961cremated
crenated113013911crenated
crested103416531crested
treated83618701treated
acerated113113982acerated
aerated85322372aerated
berated104422132berated
bleated104015972bleated
breaded115014062breaded
breamed124011592breamed
breasted1138822breasted
breathed14469642breathed
caseated11310712caseated
caveated1439132caveated
ceased94920782c_eased
cerate84829462cerate_
cerates95428252cerates
cheater124816962cheater
chelated142610482chelated
chested133811672chested
cleaned103512002cleaned
cleared103612462cleared
cleaved134010482cleaved
clefted13326752clefted
coated94927042c_oated
cocreated142710092cocreated
corelated12411822corelated
craaled10339422craaled
crafted13419772crafted
craned96121652cr_aned
craped116120522cr_aped
crate76537402cr_ate_
crater85026642cr_ater
crates85736062cr_ates
craved125417772cr_aved
crazed184714452cr_azed
creamer113714092creamer
crease85519572crease_
creaser94415742creaser
creases94020962creases
creatin93618132creatin
creator93714442creator
credited1238252credited
creed85727392cre__ed
creeled104012012creeled
creeped12329712creeped
cremate113816182cremate_
cremates124216002cremates
crenate93317112crenate_
creped114115702cre_ped
crewed125316562cre_wed
croaked143710532croaked
crusted103712752crusted
cuneated11310102cuneated
curated104717582curated
curetted1137172curetted
derated93623502derated
dreaded103612022dreaded
dreamed114310632dreamed
erected103213992erected
freaked15399702freaked
fretted113411852fretted
grated84523922gr_ated
greased93812392greased
greaten83610642greaten
greater84416492greater
greaved12408912greaved
greeted93111382greeted
heated104525592_heated
ideated9310972ideated
meated94222402_meated
ocreate93711742ocreate_
orated74221502or_ated
pleated103816632pleated
prated94924922pr_ated
preacted132710942preacted
preaged11612332preaged
predated12513272predated
rated65441382_r_ated
reacted103015712_reacted
reamed94326122_reamed
reaped94122452_reaped
reared75930012_reared
reaved104523922_reaved
rebated103619702_rebated
recreated12412532recreated
redated93120922_redated
related83327572_related
remated103522472_remated
rented74426592_rented
rested74430782_rested
retted74826312_retted
screaked15246982screaked
screamed13277602screamed
seated75131062_seated
sweated113411542sweated
teated74924022_teated
threated1259202threated
treaded95014282treaded
treater74219832treater
uncreated12312302uncreated
wreaked15369022wreaked
wreathed15257462wreathed
wrested113410932wrested

Search took 4 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 Filter1786911076710.376475242.0
2DLD Change Limit1076711143.37331921.4
3Display Results1141140.0303800.0
 (SQL Overall)1786911143.77947285.3
 
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.