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

445 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
rerack12251316(None) 
repack142412161repack
reracks132310531reracks
retack122612821retack
retrack131310721retrack
arrack121110252arrack
carack142113172carack
crack134120532_crack
prepack1757642prepack
prerace11414122prerace
prerock1536722prerock
rack106234882__rack
reach105123882re_ach
react74634332re_act
rebeck14419912rebeck
reck106130562re__ck
recock145112722recock
redact9419042redact
redock134311542redock
reface113616352reface
refract121311602refract
relace83122152relace
relock124713522relock
remark123512372remark
repacks15269542repacks
repark123511712repark
reracked15169122reracked
reran57329102rera_n
restack1339432restack
retacks132210712retacks
retrace91417342retrace
retracks14149102retracks
retract91318112retract
serac75925202serac_
seracs84418572seracs
track114823012_track
wrack145413882_wrack
aback134816173_aback
aerate64830553aerate
alack114820063_alack
amtrack15107393amtrack
arak86929573_ara_k
arracks1387733arracks
attack12148153attack
back125535763__back
bareback1846093bareback
barrack1538253barrack
beach124623893be_ach
beak106534383be_a_k
beck126226573be__ck
bedeck1536213bedeck
bedrock1645643bedrock
bemock1636173bemock
berake124216083berake
berate84729023berate
berk105929843ber__k
bipack1636523bipack
black134719073_black
brace95629273_brace
brach126123303_brach
bract96332723_bract
brank115222283_brank
breach134213723bre_ach
break115319403bre_a_k
brick134618153_brick
brock136017073_brock
caracks152211563caracks
carjack2246153carjack
carrack1548753carrack
cerate84829463cerate
cercal10314123cercal
cerci93716393cer_ci
ceric94023093ceric_
clack134720173_clack
cracks144817003_cracks
cracky175010223_cracky
crank114819613_crank
creak115418433cre_a_k
crick135118753_crick
crock135921993_crock
cruck135615323_cruck
curacy1339593curacy
debark134210943debark
deck115827753de__ck
deface123113863deface
defrock1744643defrock
demark134211023demark
derail74218813derail
derat65044083dera_t
derate74531233derate
derats74625063derats
deray95024183dera_y
derays105514253derays
derrick1435803derrick
detach12310413detach
detick1339383detick
detract101414633detract
dieback1646913dieback
drank104816203_drank
dreck124812803_dreck
each95530583_e_ach
enact73525363_enact
epact94921533_epact
era35741503_era__
eras45441503_era_s
erase54925493_erase
erect74129333_erect
erica7316543_erica
errancy1256363errancy
errand758793errand
errant6618733errant
errata639013errata
eruct74022353_eruct
exact143516933_exact
feck134923433fe__ck
feral85424653fera_l
ferals94216643ferals
fireback1946953fireback
flack144519413_flack
forerank1546753forerank
frank124417513_frank
freak125115243fre_a_k
frock145314653_frock
geck115721993ge__ck
gerah9315303gera_h
gerahs1039413gerahs
grace85124543_grace
hack135134543__hack
hatrack1638213hatrack
hayrack1945543hayrack
heck135826493he__ck
herald10311343herald
hijack2233673hijack
jack175224863__jack
jerk154920133jer__k
keck94920713ke__ck
knack104311043_knack
kyack13468263_kyack
lack105837683__lack
leach105422523le_ach
leak86233713le_a_k
legacy1256653legacy
mack125733653__mack
maraca10314153maraca
medick154010133medick
menace103216943menace
merc87225623mer_c_
merch125417963mer_ch
mercs96020453mer_cs
mercy125916183mer_cy
merk106027943mer__k
neck105423663ne__ck
orach105219233_orach
overact12315043overact
overpack1966623overpack
pack125535443__pack
peace95026083pe_ace
peach125422493pe_ach
peak106535203pe_a_k
peck125730683pe__ck
peracid12312993peracid
perch124518833per_ch
perk106232843per__k
piracy1339473piracy
plack135017843_plack
prank115019453_prank
preach133613923pre_ach
preact103220393pre_act
preface14510923preface
prefrank1764233prefrank
prelacy1437583prelacy
prepacks1836583prepacks
prick134317503_prick
quack203812503_quack
race66746263__race
racetrack1743493racetrack
racks115028853__racks
racy95825683__racy
rank85135533__rank
ransack1346463ransack
reacts83616603re_acts
read55942533re_a_d
readd74617133re_add
reads64835273re_ads
ready94821503re_ady
real45750293re_a_l
realm75621623re_alm
reals55038653re_als
ream65841613re_a_m
reams75729623re_ams
reap65934743re_a_p
reaps75626193re_aps
rear45644553re_a_r
reared75930013reared
rearer64928913rearer
rearm75923573re_arm
rearms85114653rearms
rears54739653re_ars
reata54225393re_ata
reattack1444123reattack
reave84528023re_ave
rebait8320403rebait
rebar75420193reba_r
rebars84019833rebars
rebate84424113rebate
rebato83714683rebato
rebec94416543rebec_
rebecks15288013rebecks
rebecs103913673rebecs
rebook125213203rebook
rebranch1545803rebranch
rec55645463re__c_
recall83815723recall
recane83022873recane
recant83228683recant
recap95718023reca_p
recaps103615733recaps
recast83422773recast
recce9514563re_cce
recheck1835613recheck
recks115625133re__cks
recocks154711463recocks
recook125513923recook
recork126315493recork
recrate92621663recrate
recs65734183re__cs
redacts10510943redacts
redan66125013reda_n
redans75421023redans
redate74124683redate
redbrick1742653redbrick
redcap1158493redcap
redneck1445113redneck
redocks14409933redocks
redraft11310573redraft
redraw10269853redra_w
redrawn11245953redrawn
redraws11218473redraws
reduce9713253reduce
reearn6612143reearn
reek85232523re__ek
reenact9413003reenact
reerect92915883reerect
refaced133713573refaced
refaces123216743refaces
refall94314393refall
refect114319333refect
refracts13137383refracts
refrain10310043refrain
reframe1239393reframe
regain74517763regain
regal65023793rega_l
regale74821453regale
regard85215773regard
regave104713383regave
regrade92612033regrade
regraft11310153regraft
regrant8317323regrant
regrate82618663regrate
rehab10312443reha_b
rehabs1139023rehabs
rehang1039823rehang
rehash1237433rehash
reink95518093re_ink
rejacket2166733rejacket
reject154116283reject
relaced103517213relaced
relaces93420883relaces
relaid75518443relaid
reland75920433reland
relate64033633relate
relax124817803rela_x
relay84424673rela_y
relays94316753relays
relic74623363relic_
relics84517903relics
relict83623903relict
relink104415923relink
relocks134411293relocks
relook104813743relook
reluct83916113reluct
remade94316983remade
remail85017123remail
remain85919863remain
remake124016113remake
reman75730153rema_n
remand95618963remand
remans84823003remans
remap95418103rema_p
remaps105012873remaps
remarks13329983remarks
rematch1436193rematch
remate84428683remate
renail65020763renail
renal55929503rena_l
rename82718813rename
repacked17188743repacked
repaid94716323repaid
repair84011463repair
repand95316063repand
reparks13249513reparks
repass84114703repass
repast83520633repast
repatch1435843repatch
repave114813873repave
repay104818453repa_y
repays113813973repays
reperk122511773reperk
replace113214283replace
reprice113212833reprice
reproach1544953reproach
reracking1639313reracking
reraise7316313reraise
reread71715433reread
rereads81512293rereads
rerent63832453rerent
rerig64018483rer_ig
rerigs74014793rerigs
rerise64325633rerise
reroll6412683reroll
reroof9315003reroof
rerose63320843rerose
rerun58722153rer_un
reruns66413743reruns
resaid74517083resaid
resail64418733resail
resale64025543resale
resat55139683resa_t
resaw84117253resa_w
resawn9399953resawn
resaws93713513resaws
resay85320543resa_y
resays93714153resays
resect84424703resect
reseek103813133reseek
resoak10311093resoak
respace11310913respace
restacks1438093restacks
restock1338673restock
restruck1445223restruck
retacked15169273retacked
retackle1445043retackle
retag63618413reta_g
retags73414303retags
retail65522073retail
retain64523283retain
retake104718533retake
retape83917683retape
retard75018933retard
retax124517973reta_x
retch104818303re_tch
reteach1237413reteach
retook104313443retook
retraced111413023retraced
retracer101411883retracer
retraces101417273retraces
retracked1657453retracked
retracts101111313retracts
retrain7615423retrain
retral64419743retra_l
retroact10410003retroact
retropack1742833retropack
revamp1336013revamp
rewake135218463rewake
rewan85623663rewa_n
reward106017643reward
rewarm115913493rewarm
rewash1237673rewash
rewax155713923rewa_x
rework136619793rework
rewrap11127533rewra_p
rewraps12136563rewraps
rewrapt12138113rewrapt
rick107334653__rick
rickrack1544093rickrack
ricrac1037013ricrac_
ricracs1136363ricracs
rimrock1544383rimrock
roach105717003r_oach
rock105735183__rock
roebuck1544603roebuck
roorback1654813roorback
rubace10310173rubace
ruck104728333__ruck
runback1556603runback
rural55821173rura_l
sack105337313__sack
search113312423search
sera46141393sera__
serai56830163sera_i
serail64222673serail
serais64326133serais
seral56336383sera_l
serape84818413serape
seraph114011163seraph
setback1567143setback
shack145321753_shack
shrank13359123shrank
slack115021763_slack
smack134615453_smack
snack114718063_snack
stack114421693_stack
strick124813203strick
struck12489263struck
tack106536293__tack
teach105221123te_ach
teak85930843te_a_k
tenace82715693tenace
terai53525483tera_i
terais64023513terais
teraph11319093teraph
terce75721843ter_ce
terrace93311843terrace
thack144915173_thack
thwack1834213thwack
tieback1547103tieback
trace75829613_trace
tracks124818843_tracks
tract75635713_tract
traik95418203_traik
trank96222423_trank
trick115420693_trick
tripack1565673tripack
trock114817603_trock
truck116115463_truck
turaco839453turaco
umiack1435173umiack
unpack1457833unpack
untack1239763untack
untrack1338703untrack
vera76828843vera__
wack135330913__wack
weak117126303we_a_k
wetback1875613wetback
whack174813023_whack
wracks154711113_wracks
wreak125513273wre_a_k
wreck144611043_wreck
wrick144013393_wrick
xerarch1943843xerarch
xeric144315663xeric_
yack135425973__yack
yerk116222083yer__k
zebeck23255203zebeck
zerk175319253zer__k

Search took 6 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.393454684.5
2DLD Change Limit1127164455.00022543.2
3Display Results4454450.1403178.6
 (SQL Overall)1786914455.53332295.5
 
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.