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

372 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
reteams933956(None) 
reteam83214531reteam_
retears72814921retears
retems83914571rete_ms
jetsams16124102jetsams
preterms1237222preterms
reams75729622r__eams
redears82814452redears
redeems1037162redeems
redreams1195952redreams
regears83012462regears
rehears103312772rehears
reheats104513532reheats
rehems113410982rehe_ms
repeals94014532repeals
repeats94316062repeats
rereads81512292rereads
reseals73917682reseals
reseats74319592reseats
reseaus74012152reseaus
retags73414302ret_ags
reteach1237412reteach
reteamed1138012reteamed
retear63115482retea_r
retells73211522retells
retem74221952rete_m_
retenes76324622retenes
retests73813852retests
retreads937822retreads
retreats8311422retreats
retrims93612372retrims
reveals103812742reveals
rewears102911042rewears
steams84916902_steams
teams75726512__teams
aretes64425363arete__s
beams95328173__beams
bedlams1237053bedlams
beheads1338523beheads
beldams1237053beldams
beleaps1138053beleaps
bemeans1148743bemeans
beseems1175913beseems
besteads11307123besteads
betas75528763bet_a_s
betels84515063bete_ls
betrays12127823betrays
bettas84913923betta_s
breams104815053_breams
brechams1745783brechams
cereals9313173cereals
cetes75731103cete__s
creams104715253_creams
debeaks1436103debeaks
deems85421773de_e_ms
defeats113511233defeats
defoams1336193defoams
degerms1135623degerms
deleads9379703deleads
demeans1039723demeans
deperms1236603deperms
detects104011093detects
detents83615153detents
deters74724683dete_rs
detests83711743detests
dreams94513983_dreams
edemas9310503_edemas
enemas8812003_enemas
esteems935243esteems
etas46432273_et_a_s
etnas54713933_etna_s
exams14199083_e_xams
eyebeams1542133eyebeams
ferbams1435743ferbams
fetas85624403fet_a_s
fetes85630143fete__s
fetials103711743fetials
fleams115011943_fleams
fretsaws1442763fretsaws
gateaus866333gateaus
getas65421483get_a_s
gleams94812253_gleams
heteros10312683heteros
hetmans12187593hetmans
inseams9307903inseams
items7499613_ite_ms
jetbeads1842483jetbeads
jetes124922843jete__s
jetlags1533863jetlags
jetsam15116323jetsam_
jetsoms16124723jetsoms
jetways2094053jetways
ketenes114813503ketenes
lethals1038113lethals
meseems1165603meseems
metals84520893met_als
meteors94610013meteors
metepas1136303metepas
meters85625833mete_rs
metes74736213mete__s
neems77316293ne_e_ms
oedemas1056693oedemas
outbeams1236063outbeams
outeats72215703outeats
petals84719813pet_als
peters86624593pete_rs
petnaps1145033petnaps
petsais938433petsais
preheats1339423preheats
preteens1038123preteens
pretells1047333pretells
pretends11299113pretends
preterm11310163preterm_
pretests10310013pretests
pretexts1735603pretexts
pretreats1146933pretreats
pretrims1238983pretrims
proteans102811543proteans
proteas92015123protea_s
rams65950773r___ams
ratals64219583rat_als
ratans63819373rat_ans
ratbags1035763ratbags
ratels64518213rate_ls
raters63936583rate_rs
rates55352013rate__s
rattans73411953rattans
reads64835273r__eads
realms84913493re_alms
reals55038653r__eals
ream65841613r__eam_
reaps75626193r__eaps
rearms85114653re_arms
rears54739653r__ears
reatas64021023reata_s
rebars84019833re_bars
rebecks15288013rebecks
rebecs103913673rebe_cs
rebels84518133rebe_ls
recaps103615733re_caps
recedes102816063recedes
recepts113010273recepts
recess8314263rece_ss
recheats1339193recheats
reclads1049993reclads
reclaims1236113reclaims
reclame11411063reclame
reclames12310893reclames
recleans1037513recleans
recoals94214633recoals
recoats92616653recoats
rectums11338523rectums
redans75421023re_dans
redbays1336013redbays
redcaps1247073redcaps
redear73515173redea_r
redeem9311533redeem_
redes65139133rede__s
redeyes112910973redeyes
redheads1336173redheads
redials84416893redials
redias74523613redia_s
redraws11218473redraws
redream10107913redream_
redreamt11127183redreamt
reearn6612143re_earn
reearns749103re_earns
reeds65430903re_e_ds
reefs85121663re_e_fs
reeks94124033re_e_ks
reels55333263re_e_ls
rees45364193re_e__s
reests64618893re_ests
reeves94721493re_eves
refects124012743refects
refeeds11368973refeeds
refeels10379693refeels
refels94618053refe_ls
refers93921083refe_rs
refilms12347503refilms
reflags1156953reflags
reforms1239823reforms
reframe1239393reframe
reframes1338993reframes
regear73512743regea_r
regents83416543regents
reges65628793rege__s
reggaes948883reggaes
rehabs1139023re_habs
rehear93713223rehea_r
reheard11309023reheard
rehearse11296663rehearse
reheat94423943rehea_t
reheels10298253reheels
rehem103815353rehe_m_
rejects163910693rejects
rekeys13347693reke_ys
relays94316753re_lays
relearn747973relearn
relearns836303relearns
release7312763release
releases8313343releases
relends84013253relends
relents74018503relents
relets64025673rele_ts
releves103914973releves
reloads8911313reloads
reloans7313133reloans
remans84823003re_mans
remaps105012873re_maps
remeets93712413remeets
remelts93511493remelts
remends105013033remends
rems66237723r__e_ms
rename82718813re_name
renames92418053re_names
reneges82513593reneges
renests74014213renests
renewals1137283renewals
renews93811753rene_ws
rentals74017483rentals
renters74224823rente_rs
rentes65431193rente__s
repass84114703re_pass
repays113813973re_pays
repeal84718293repea_l
repeat85127213repea_t
repegs93311943repe_gs
repels84318763repe_ls
repents93717623repents
reperks13298093reperks
replans92814943replans
replays12399763replays
repleads11357213repleads
reread71715433rerea_d
reredos838633reredos
rerents73319423rerents
resaws93713513re_saws
resays93714153re_says
reseal64819653resea_l
reseat64131493resea_t
reseau64216213resea_u
reseaux14326233reseaux
resects94115593resects
resedas839123resedas
reseeds84012333reseeds
reseeks11348623reseeks
resees63827483rese_es
resells73313203resells
resends83513713resends
resents74221223resents
resets65427613rese_ts
resews94814173rese_ws
resoaks1148973resoaks
respeaks1434953respeaks
restamp1146483restamp
restamps1234703restamps
resters74130403reste_rs
retack122612823ret_ack
retacks132210713retacks
retag63618413ret_a_g
retail65522073ret_ail
retails74718973retails
retain64523283ret_ain
retains74522253retains
retake104718533ret_ake
retakes113718863retakes
retape83917683ret_ape
retapes93917423retapes
retard75018933ret_ard
retards85015003retards
retax124517973ret_a_x
retaxes143615093retaxes
retches123318513retches
rete44944133rete___
reteaches1437123reteaches
reteaming122110443reteaming
retell63813643rete_ll
retene69224273rete_ne
retest64028453rete_st
rethreads1344483rethreads
retia55326113retia__
retial64724993retia_l
retiary1038333retiary
reties65436193ret_ies
retiles74426993retiles
retime85321803ret_ime
retimes95020173retimes
retinals85612963retinals
retinas74819353retinas
retines75134673retines
retints74717023retints
retires74726213retires
retools73411023retools
retorts76016513retorts
retotals838463retotals
retrace91417343retrace
retraces101417273retraces
retrack131310723retrack
retracks14149103retracks
retract91318113retract
retracts101111313retracts
retrain7615423retrain
retrains8314533retrains
retral64419743retra_l
retread849003retrea_d
retreat7317533retrea_t
retrials8510823retrials
retries74129073retries
retrim83514883retrim_
retros63820193ret_ros
rets45352563ret___s
retunes76918403retunes
returns79712593returns
retypes12308623retypes
revamp1336013re_vamp
revamps1434003re_vamps
reveal94115063revea_l
revels94220573reve_ls
reverbs12368863reverbs
reveres103621343reveres
revers94529633reve_rs
reverts104715053reverts
revests104413743revests
revets94022183reve_ts
rewarms12439603rewarms
rewear93012003rewea_r
reweave1336773reweave
reweaves1436603reweaves
reweds104412303rewe_ds
rewelds11457413rewelds
rewets94617213rewe_ts
rewraps12136563rewraps
rexes124526953rexe__s
rezeros1647453rezeros
rheas84816953r_hea_s
rheums1135463r_heums
rites54442553rite__s
rituals738353rituals
roams74919613r__oams
rotas54827723rot_a_s
rotes56143903rote__s
screams114810623screams
seams75731663__seams
seems75525023se_e_ms
steads74116223_steads
steaks104415853_steaks
steals64020063_steals
steam76322933_steam_
steamy115112373_steamy
stems75219953_ste_ms
streams94713373streams
tams67247933__t_ams
teaks94222903__teaks
teals56234133__teals
team66238653__team_
tears55436463__tears
teas45851493__tea_s
teats55636813__teats
teems76019783__teems
terms75523473__terms
tetrads82910193tetrads
tetras63017623tetra_s
totems86810763tote_ms
trams75327673__trams
unseams9338913unseams
uptears9106453uptears
ureters7311823urete_rs
urethans1145243urethans
veterans1148853veterans
webcams1643073webcams
zetas145018163zet_a_s

Search took 8 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 Filter1786911340270.656272394.8
2DLD Change Limit1340273726.39020974.5
3Display Results3723720.1402657.1
 (SQL Overall)1786913727.18624866.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.