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

210 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
resh7652345(None) 
fresh115012201fresh
mesh96823001mesh
rash76039931rash
res35565041res_
rest46459841rest
rush76628181rush
afresh1255502afresh
ares45871022ares_
ash67944602_ash
bash915240162bash
bes56557432bes_
best66355322best
beth96629232beth
bosh96328972bosh
brash106221562brash
brush105917472brush
bush96630712bush
cash96636282cash
cess65326052cess
cosh96127622cosh
crash109120012crash
creesh11328332creesh
cress75022832cress
crest74632692crest
crush106815992crush
dash87031632dash
deash95617242deash
desk95618902desk
dish86328332dish
dress65319832dress
drest65530342drest
edh76921562_edh
eh58339962_e_h
ers36046282ers_
erst47436432erst
es29048222_es_
ess36030882_ess
eth66630982_eth
fash107232292fash
feh96136092fe_h
fehs106522382fehs
fes66551672fes_
fess76529162fess
fest74949442fest
fish106926272fish
flesh115013742flesh
frosh115713402frosh
gash86833022gash
gest56149132gest
gosh86123422gosh
gush85424002gush
hash106936502hash
heh96039622he_h
hehs106723962hehs
hes66654202hes_
hest75950772hest
heth107028022heth
hush105224112hush
ires45639282ires_
jess116022032jess
jest116738502jest
josh145117612josh
lash76539652lash
leash85519212leash
lech96825442lech
les35663072les_
less45635102less
lest46956322lest
lush75327692lush
mash96039392mash
mensh105413552mensh
mesa67025482mesa
meshy135612782meshy
mess65932432mess
meth95827842meth
mosh95227602mosh
mush94929122mush
ness45526562ness
nest45548732nest
nosh76223542nosh
oes35866192oes_
ores46056682ores_
pash95638132pash
pech116125452pech
peh86740962pe_h
pehs95625762pehs
pes57259782pes_
peso66925822peso
pest65555292pest
pish96127912pish
posh95427322posh
presa74319042presa
prese75228382prese
press75425952press
prest75736352prest
push95526622push
rah68052402r_ah
ras37575392ras_
rase46149982rase
rasp66029162rasp
rath76037662rath
re26153742re__
reach105123882reach
read55942532read
real45750292real
ream65841612ream
reap65934742reap
rear45644552rear
reb55844962re_b
rebs65733562rebs
rec55645462re_c
reck106130562reck
recs65734182recs
red46755802re_d
redd66323172redd
rede55037662rede
redo56029362redo
reds56042862reds
ree37974072re_e
reed55549622reed
reef74938212reef
reek85232522reek
reel45240532reel
rees45364192rees
reest54938092reest
ref66053292re_f
refs75732242refs
reft75141272reft
reg46146492re_g
regs55436572regs
rehash1237432rehash
rei35647252re_i
reif76937652reif
rein46040892rein
reis45343232reis
relish93916952relish
rely75428952rely
rem56150042re_m
rems66237722rems
rend56136572rend
rent46661242rent
rep55847802re_p
repo66027542repo
repp85418742repp
reps65937952reps
resat55139682resat
resaw84117252resaw
resay85320542resay
resee54336332resee
reset55051862reset
resew84519502resew
reshes94124362reshes
reship11310672reship
reshod103012232reshod
reshoe92816482reshoe
reshot93519632reshot
reshow123111432reshow
resid64124092resid
resin54131052resin
resit54241042resit
resod64720052resod
resow88217242resow
rests54935872rests
ret35982832re_t
retch104818302retch
rete44944132rete
rets45352562rets
reuse56025362reuse
rev65336622re_v
revs75027052revs
rewash1237672rewash
rex105740992re_x
rich97025542rich
rise45945232rise
rishi8311252rishi
risk85724102risk
roes45954132roes_
rose46148902rose
roshi8310752roshi
rosy76024872rosy
rues46044482rues_
ruse45938932ruse
rushy115414812rushy
rusk85823312rusk
rust45544912rust
ruth76825992ruth
ryes75529352ryes_
sash77235302sash
sh56828522__sh
tech95925442tech
test48651622test
teth76327882teth
thresh12276862thresh
tosh74826812tosh
trash86119762trash
tres46542902tres_
tress55423162tress
tush74523902tush
vest75743602vest
wash106033812wash
welsh113110362welsh
west75748082west
wish107228732wish
wrest84925432wrest
yeah106725412yeah
yech127220532yech
yeh97135772ye_h
yes66250612yes_
zest136035702zest

Search took 2 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 Filter178691298720.0802233637.5
2DLD Change Limit298722101.11026911.7
3Display Results2102100.0464565.2
 (SQL Overall)1786912101.236144572.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.