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 “resewo” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

298 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
resew84519501resew_
resewn9459811resewn
resews94814171resews
pesewa1135542pesewa
renew83917512renew_
renews93811752renews
resaw84117252resaw_
resawn9399952resawn
resaws93713512resaws
reseal64819642reseal
reseat64131492reseat
reseau64216212reseau
resect84424702resect
reseda739702reseda
resee54336332rese_e
reseed74823292reseed
reseek103813132reseek
reseen64318412reseen
resees63827482resees
resell64215202resell
resend75016772resend
resent63833622resent
reset55051862rese_t
resets65427612resets
resewed113011822resewed
reshow123111432reshow
resow88217242resow_
resown94112922resown
resows93915352resows
rezero1578872rezero
arseno6318913arseno
bedew114513033bedew_
bedews12398943bedews
beseem1069083beseem
beses75830723bese_s
beset76739133bese_t
besets85718803besets
besnow1145713besnow
bestow1149463bestow
desert72725493desert
desex13311983dese_x
erses55826803erse_s
eses45336103_ese_s
fresco1136473fres_co
gesso649603ges_so
hereto9313693hereto
hetero9312633hetero
lesbo739253les_bo
leses54930813lese_s
mesteso937133mesteso
paseo77022513pase_o
peseta8310573peseta
pesewas1236223pesewas
peso66925823pes__o
pesto75723723pes_to
prese75228383prese__
presell939293presell
present94022723present
preset84430983prese_t
presets94216423presets
preshow15237413preshow
presto84216203pres_to
rase46149983rase__
rased65033933rase_d
raser55633413rase_r
rasers64526783rasers
rases55447213rase_s
reavow1235723reavow
rebato83714683rebato
rebec94416543rebe_c
rebeck14419913rebeck
rebecs103913673rebecs
rebel73421293rebe_l
rebels84518133rebels
rebozo1737323rebozo
recede95515533recede
recent83630853recent
recept103319073recept
recess8314263recess
rechew14310213rechew_
rechews1537293rechews
recto74520803re_cto
rede55037663rede__
redear73515173redear
reded74829113rede_d
redeem9311523redeem
redefy13388763redefy
redeny102712733redeny
redes65139123rede_s
redeye103811793redeye
redo56029363r__edo
redowa1038453redowa
redrew10309503redrew_
ree37974073re_e__
reecho11318653reecho
reed55549623re_e_d
reeds65430903re_eds
reedy910020283re_edy
reef74938213re_e_f
reefs85121663re_efs
reefy114217703re_efy
reek85232523re_e_k
reeks94124033re_eks
reeky125416263re_eky
reel45240533re_e_l
reels55333263re_els
rees45364193re_e_s
reest54938093re_est
reests64618893reests
reeve84121323re_eve
refect114319333refect
refed93921923refe_d
refeed104717623refeed
refeel93913243refeel
refel84920813refe_l
refell94214443refell
refels94618053refels
refelt94521423refelt
refer84822143refe_r
refers93921083refers
reflew12389453reflew_
reflow12379653reflow
regear73512743regear
regent74127673regent
reges65628783rege_s
reglow10339403reglow
regrew10388563regrew_
regrow10309883regrow
rehear93713223rehear
reheat94423943reheat
reheel93610823reheel
rehem103815353rehe_m
rehems113410983rehems
reject154116283reject
rekey124014733reke_y
rekeys13347693rekeys
relend76116453relend
relent64431853relent
relet54749823rele_t
relets64025673relets
releve95116403releve
relievo10425773relievo
relleno796463relleno
remedy1237863remedy
remeet86325473remeet
remelt85123123remelt
remend95216553remend
remet74843723reme_t
remex146315793reme_x
renege72713763renege
renest64529713renest
renewal1038703renewal
renewed11309993renewed
renewer10248693renewer
renown9369983renown
repeal84718283repeal
repeat85127213repeat
repeg84015053repe_g
repegs93311943repegs
repel74921403repe_l
repels84318763repels
repent84728873repent
reperk122511773reperk
replow114210343replow
repo66027543r__epo
repro75315913re_pro
reread71715433reread
reredos838633reredos
rerent63832453rerent
res35565043res___
resaid74517083resaid
resail64418733resail
resale64025543resale
resat55139683res_at
resawed113111183resawed
resay85320543res_ay
resays93714153resays
rescue8313003rescue
reseals73917663reseals
reseason844933reseason
reseats74319583reseats
reseaus74012153reseaus
reseaux14326233reseaux
resects94115593resects
resedas839123resedas
reseeds84012333reseeds
reseeks11348623reseeks
reseize1639553reseize
resells73313203resells
resends83513713resends
resents74221223resents
reserve101011203reserve
resewing122712263resewing
resh76523453res__h
reshes94124363reshes
reship11310673reship
reshod103012233reshod
reshoe92816483reshoe
reshoot102513893reshoot
reshot93519633reshot
reshown13257903reshown
reshows132510453reshows
resid64124093res_id
reside74224933reside
resids74219153resids
resift94017723resift
resign74212583resign
resile64627673resile
resin54131053res_in
resins64528773resins
resiny94617363resiny
resist64524533resist
resit54241043res_it
resite64128453resite
resits64725563resits
resize154117723resize
resmelt9411773resmelt
resoak10311093resoak
resod64720053res_od
resods74116303resods
resold73915363resold
resole64624183resole
resorb84914343resorb
resort65728613resort
resowed113712253resowed
respeak1335933respeak
respect11412033respect
respell947023respell
respelt9312143respelt
respool937633respool
respot83117633respot
rest46459843res__t
rested74430783rested
rester63832433rester
resters74130403resters
rests54935873res_ts
result6318223result
resume8313783resume
rete44944133rete__
reteam83214533reteam
retear63115483retear
retell63813643retell
retem74221953rete_m
retems83914573retems
retene69224273retene
retest64028453retest
retro55020953re_tro
reuse56025363reuse__
reused75419563reuse_d
reuses66025523reuse_s
reveal94115053reveal
revel84423163reve_l
revels94220573revels
reverb113912573reverb
revere94621253revere
revers94529633revers
reverso10367693reverso
revert93529113revert
revery124014213revery
revest94623603revest
revet84938843reve_t
revets94022173revets
review1238693review_
reviews1335533reviews
rewear93011993rewear
rewed95425453rewe_d
reweds104412303reweds
reweld103711113reweld
rewet85135153rewe_t
rewets94617213rewets
rewon86920573r__ewon
rexes124526953rexe_s
rezeros1647453rezeros
rise45945233rise__
risen54621883rise_n
riser55431053rise_r
risers64624783risers
rises55244043rise_s
rodeo65921093rode_o
romeo73719703rome_o
rose46148903rose__
rosed65930343rose_d
rosery93813283rosery
roses56445773rose_s
roset55945243rose_t
rosets65819953rosets
rosewood1245643rosewood
ruse45938933ruse__
ruses56136583ruse_s
sego56525183__sego
sew66247263__sew_
sewn76124333__sewn
sews75836023__sews
teredo7310783teredo
unsew83912693unsew_
unsewn9298393unsewn
unsews9379363unsews
yeses85119323yese_s

Search took 7 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 Filter1786911127160.203880251.2
2DLD Change Limit1127162986.09318499.3
3Display Results2982980.0963104.2
 (SQL Overall)1786912986.39227955.4
 
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.