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

195 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
cress7502283(None) 
caress85720261caress
cess65326051c_ess
chess105016921chess
crass76328041crass
creds85418771creds
cressy11439111cressy
crest74632691crest
crests85218701crests
crews105917491crews
cross75124501cross
dress65319831dress
press75425951press
tress55423161tress
access1037672access
acres76327762acre_s
across8312642across
actress948532actress
ancress978612ancress
areas55935772areas
ares45871022are_s
arses55733872arses
bless75917812bless
brass75428022brass
brees75632552brees
brens75823362brens
brews105617072brews
briss75824272briss
carers85133952carers
cares77369182care_s
carets85330772carets
carless95118492carless
carses85233652carses
cases75048382cases
cees65941592c_ees
cels65534972c_els
ceps86125952c_eps
ceres75540012ceres
cereus85215522cereus
ceros74726072ceros
chefs136214662chefs
chest104926142chest
chests114916262chests
chews135418512chews
cires74932912cire_s
class75525482class
clefs106616242clefs
clews105516332clews
coeds85920162coeds
corers85231072corers
cores76361852core_s
corses84433462corses
coses76949492coses
coss66143492c_oss
crabs95421392crabs
crags85622572crags
crams96229152crams
craps95328642craps
crases85532312crases
crash109120012crash
crasis85020472crasis
craws105723122craws
creak115418432creak
creaks124315962creaks
cream95721342cream
creams104715252creams
crease85519572crease
creases94020962creases
creasy114612302creasy
cred76530882cre_d
credo84815562credo
credos94612842credos
creed85727392creed
creeds94714772creeds
creek114917392creek
creeks124812922creeks
creel75121482creel
creels84416942creels
creep95218102creep
creeps104213622creeps
creese84014332creese
creeses93914622creeses
creesh11328332creesh
creme94319322creme
cremes104517992cremes
crepe95520722crepe
crepes105419342crepes
crept95125892crept
crepy124812702crepy
cresol8310202cresol
cresols939642cresols
cresses94219812cresses
cresset93319942cresset
cresyl1135132cresyl
cresyls1234752cresyls
crew96122672cre_w
cribs94516742cribs
criers83918582criers
cries75438402cries
cris66233432cr_is
crises84529432crises
crisis83716342crisis
crisp95014622crisp
crisps104411512crisps
crissa837622crissa
crits75527572crits
crocs95722432crocs
crops96125232crops
crosse85216302crosse
crows105727312crows
cruds85815852cruds
cruets85314952cruets
crus65828482cr_us
cruse75726102cruse
cruses88127712cruses
crush106815992crush
crust75827662crust
crusts84916542crusts
cues65438982cue_s
curers84923182curers
cures75645432cure_s
curets84922342curets
curses85328272curses
cuss65430612c_uss
cyeses11510122cyeses
cyesis1148572cyesis
cypress1434652cypress
drees65628522drees
dregs76114862dregs
dreks105714742dreks
dressy10518142dressy
drest65530342drest
dross65418092dross
duress74712062duress
egress73310432egress
erses55826802erses
ess36030882__ess
fess76529162_fess
frass85321122frass
frees86131392frees
fresh115012202fresh
frets85523402frets
grass66125202grass
grees65132472grees
greys96614852greys
gross65421692gross
guess64213362guess
ires45639282ire_s
jess116022032_jess
less45635102_less
loess55714702loess
mess65932432_mess
ness45526562_ness
ogress7529502ogress
ores46056682ore_s
prees75937172prees
preps96220692preps
presa74319042presa
prese75228382prese
prest75736352prest
prests84021262prests
preys105717782preys
priss74623892priss
pross76529402pross
rebs65733562_rebs
recs65734182_recs
reds56042862_reds
rees45364192_rees
refs75732242_refs
regs55436572_regs
reis45343232_reis
rems66237722_rems
reps65937952_reps
res35565042_re_s
resh76523452_resh
rest46459842_rest
rests54935872_rests
rets45352562_rets
revs75027052_revs
screes85023962screes
screws115513882screws
stress66616672stress
trass56226472trass
trees55835762trees
treks96016852treks
tres46542902tre_s
tressy9448552tressy
trets55928022trets
trews86118892trews
treys85018212treys
truss54916922truss
ureas55826012ureas
wrens85016242wrens
wrest84925432wrest
wrests95313082wrests

Search took 5 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 Filter178691538000.296603685.8
2DLD Change Limit538001954.12613039.3
3Display Results1951950.1231585.4
 (SQL Overall)1786911954.54539316.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.