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

123 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
create8512638(None) 
cerate84829461cerate
crate76537401cr_ate
crease85519571crease
created104323451created
creates95225201creates
cremate113816181cremate
crenate93317111crenate
ocreate93711741ocreate
acerate92818912acerate
acreage1037842acreage
aerate64830552aerate
areae55229742area_e
arete56031352are_te
aureate72515282aureate
berate84729022berate
breath113916262breath
breathe123711842breathe
carate84734002carate
caseate9314782caseate
cate66254602c__ate
cease75227652c_ease
cerated103922472cerated
cerates95428252cerates
cerite84724872cerite
cete64934782c_e_te
cheat105732452cheat_
cheated134416342cheated
cheater124816962cheater
cheats114519542cheats
chelate122914892chelate
cirrate92413492cirrate
cleat76335062cleat_
cleated103417842cleated
cleats84919312cleats
cleave114212512cleave
cocreate122611812cocreate
comate104124842comate
cordate10315222cordate
corelate10516012corelate
crake114823522cr_ake
crane75331602cr_ane
crape96128442cr_ape
crated94827772cr_ated
crater85026642cr_ater
crates85736062cr_ates
crave105626312cr_ave
craze165221462cr_aze
creak115418432crea_k
creaked143413232creaked
creaks124315962creaks
creaky154911552creaky
cream95721352crea_m
creamed123913712creamed
creamer113714092creamer
creams104715252creams
creamy134811362creamy
creased104315582creased
creaser94415732creaser
creases94020962creases
creasy114612302creasy
creatin93618132creatin
creatine103417412creatine
creative132812802creative
creator93714442creator
creature1038732creature
creche13310762creche
creese84014332creese
cremated133412962cremated
cremates124216002cremates
creme94319322cre_me
crenated113013912crenated
creole8913732creole
crepe95520722cre_pe
crept95125892crept_
crest74632692crest_
crested103416532crested
crests85218702crests
crewmate15405632crewmate
croute84617272croute
cuneate9311722cuneate
curate85226242curate
curette939782curette
curtate9312642curtate
derate74531232derate
ergate7315142ergate
grate64932882gr_ate
grease75416232grease
great66034242great_
greaten83610642greaten
greater84416492greater
greats76318392greats
greave104611492greave
ideate7313682ideate
increate10312202increate
irate55627982ir_ate
ocreae83310272ocrea_e
oleate6318882oleate
orate55133302or_ate
ornate6315142ornate
prate75135982pr_ate
predate10616892predate
prelate9519692prelate
rate45458762_r_ate
reata54225392_reata
reave84528022_reave
rebate84424112_rebate
recreate10313602recreate
redate74124682_redate
relate64033632_relate
remate84428682_remate
rente54733782_rente
rete44944132_re_te
treat56240352treat_
treated83618702treated
treater74219832treater
treats64821692treats
treaty94414352treaty
uncreate10311352uncreate
urate55432162ur_ate
urease64516992urease
wreath124111192wreath
wreathe13339052wreathe

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 Filter178691825510.343520965.0
2DLD Change Limit825511232.73630172.1
3Display Results1231230.0462673.9
 (SQL Overall)1786911233.12557181.1
 
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.