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

420 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
repack14241216(None) 
prepack1757641prepack
repacks15269541repacks
repark123511711repark
rerack122513161rerack
retack122612821retack
bipack1636522bipack
epact94921532_epact
pack125535442__pack
prepacks1836582prepacks
rack106234882r__ack
reach105123882re_ach
react74634332re_act
rebeck14419912rebeck
reck106130562re__ck
recock145112722recock
redact9419042redact
redock134311542redock
reface113616352reface
relace83122152relace
relock124713522relock
remark123512372remark
repacked17188742repacked
repaid94716322repaid
repair84011462repair
repand95316062repand
reparks13249512reparks
repass84114702repass
repast83520632repast
repatch1435842repatch
repave114813872repave
repay104818452repa_y
repays113813972repays
reperk122511772reperk
replace113214282replace
reracks132310532reracks
respace11310912respace
restack1339432restack
retacks132210712retacks
retrack131310722retrack
tripack1565672tripack
unpack1457832unpack
aback134816173_aback
alack114820063_alack
alpaca1047383alpaca
apace94718383_apace
apeak115513453apea_k
arepa75615563arepa__
arepas85515703arepa_s
arrack121110253arrack
attack12148153attack
back125535763__back
bareback1846093bareback
beach124623893be_ach
beak106534383be_a_k
beck126226573be__ck
bedeck1536213bedeck
bemock1636173bemock
bipacks1745043bipacks
black134719073_black
breach134213723bre_ach
break115319403bre_a_k
calpack17338333calpack
carack142113173carack
clack134720173_clack
copeck1636943copeck
crack134120533_crack
creak115418433cre_a_k
debark134210943debark
deck115827753de__ck
deface123113863deface
demark134211023demark
depart94720563depart
depict113514793depict
detach12310413detach
detick1339383detick
dieback1646913dieback
dreck124812803dre__ck
each95530583_e_ach
enact73525363_enact
epacts105010393_epacts
eparch13258423_eparch
epic86921303_epic_
epics95014283_epics
epoch1248203_epoch
exact143516933_exact
feck134923433fe__ck
fireback1946953fireback
flack144519413_flack
freak125115243fre_a_k
geck115721993ge__ck
gripsack1742583gripsack
hack135134543__hack
hardpack2043923hardpack
heck135826493he__ck
henpeck1843083henpeck
hepcat13611823hepcat
hijack2233673hijack
hopsack1845273hopsack
impact122310453impact
impark14287073impark
jack175224863__jack
keck94920713ke__ck
knack104311043_knack
kopeck1333423kopeck
kreplach1942613kreplach
kyack13468263_kyack
lack105837683__lack
leach105422523le_ach
leak86233713le_a_k
legacy1256653legacy
mack125733643__mack
manpack1746063manpack
medick154010133medick
menace103216943menace
mudpack1843593mudpack
neck105423663ne__ck
overpack1966623overpack
pac79054083__pac_
paca85132243__paca
pace86345773__pace
packs135528933__packs
pacs85842183__pacs
pact86648723__pact
pacy115328683__pacy
paik105726803__paik
papacy1547493papacy
park105237493__park
peace95026083pe_ace
peach125422493pe_ach
peak106535203pe_a_k
peck125730683__peck
peptalk1554823peptalk
pick125933813__pick
plack135017843_plack
pock126129293__pock
preach133613923pre_ach
preact103220393pre_act
preface14510923preface
prelacy1437583prelacy
prepacked20155643prepacked
prepaid12310133prepaid
prepare111913623prepare
prepave14228873prepave
prepay13310313prepa_y
prepays1437483prepays
preplace1488973preplace
prepuce1337833prepuce
prerace11414123prerace
prerock1536723prerock
puck124927943__puck
quack203812503_quack
race66746263r__ace
racks115028853r__acks
racy95825683r__acy
rank85135523r__ank
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
reaped94122453reaped
reaper84223143reaper
reaps75626193re_aps
rear45644553re_a_r
rearm75923563re_arm
rears54739653re_ars
reata54225393re_ata
reattack1444123reattack
reave84528023re_ave
rebait8320403rebait
rebar75420193reba_r
rebars84019823rebars
rebate84424103rebate
rebato83714683rebato
rebec94416543rebec_
rebecks15288013rebecks
rebecs103913673rebecs
rebook125213203rebook
rec55645463re__c_
recall83815723recall
recane83022873recane
recant83228683recant
recap95718023reca_p
recaps103615733recaps
recast83422773recast
recce9514563re_cce
recheck1835613recheck
recks115625133re__cks
recocks154711463recocks
recook125513923recook
recork126315483recork
recs65734183re__cs
redacts10510943redacts
redan66125013reda_n
redans75421023redans
redate74124683redate
redcap1158493redcap
redneck1445113redneck
redocks14409933redocks
reduce9713253reduce
reearn6612143reearn
reek85232523re__ek
reenact9413003reenact
refaced133713573refaced
refaces123216743refaces
refall94314393refall
refect114319333refect
refract121311603refract
regain74517763regain
regal65023793rega_l
regale74821453regale
regard85215773regard
regave104713383regave
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
rep55847803rep___
repacify1843483repacify
repackage1842713repackage
repacking1838283repacking
repaint9318363repaint
repairs9319973repairs
repanel939963repanel
repaper11310023repaper
reparked15208923reparked
repasts93611933repasts
repaved133311133repaved
repaves123513653repaves
repeal84718283repeal
repeals94014523repeals
repeat85127213repeat
repeats94316053repeats
repeg84015053rep_eg
repegs93311943repegs
repel74921403rep_el
repels84318763repels
repent84728873repent
reperks13298093reperks
repin75324703rep_in
repine85627813repine
repins84924313repins
replaced133211393replaced
replacer12279743replacer
replaces123114123replaces
replan83215823replan
replans92814943replans
replant93318533replant
replate93420053replate
replay113412923replay
replays12399763replays
repled93319773repled
replica1137943replica
replot83818593replot
replow114210343replow
reply104015853rep_ly
repo66027543rep__o
repoll8410793repoll
report85326013report
repos74725793rep_os
repose84121413repose
repot75132623rep_ot
repots85621003repots
repour8310993repour
repp85418743rep__p
repped114616723repped
repps95114343rep_ps
reprice113212833reprice
repro75315913rep_ro
reproach1544953reproach
repros84216003repros
reps65937953rep__s
reptant92817073reptant
repugn946493repugn
repump1235683repump
repute84716093repute
reracked15169123reracked
reran57329103rera_n
resaid74517083resaid
resail64418733resail
resale64025543resale
resat55139683resa_t
resaw84117253resa_w
resawn9399953resawn
resaws93713513resaws
resay85320543resa_y
resays93714153resays
resect84424703resect
reseek103813133reseek
resoak10311093resoak
respaced1338503respaced
respaces12311043respaces
respade1039573respade
respeak1335933respeak
respect11412033respect
restacks1438093restacks
restock1338673restock
retacked15169273retacked
retackle1445043retackle
retag63618413reta_g
retags73414303retags
retail65522073retail
retain64523283retain
retake104718533retake
retape83917683retape
retard75018933retard
retax124517973reta_x
retch104818303re_tch
reteach1237413reteach
retook104313443retook
retrace91417343retrace
retracks14149103retracks
retract91318113retract
retropack1742833retropack
revamp1336013revamp
rewake135218463rewake
rewan85623663rewa_n
reward106017633reward
rewarm115913483rewarm
rewash1237673rewash
rewax155713923rewa_x
rework136619783rework
rick107334653r__ick
roach105717003r_oach
rock105735183r__ock
roebuck1544603roebuck
rubace10310173rubace
ruck104728333r__uck
runback1556603runback
sack105337313__sack
sepal77723003sepa_l
sepals85217373sepals
sepic94617053sepic_
serac75925203serac_
seracs84418573seracs
setback1567143setback
shack145321753_shack
shoepack1943783shoepack
slack115021763_slack
smack134615453_smack
snack114718063_snack
space95325673_space
spacy125415623_spacy
spank115919573_spank
spark114920893_spark
speak114618673spea_k
speck135115653_speck
spick134519073_spick
stack114421693_stack
tack106536293__tack
teach105221123te_ach
teak85930843te_a_k
tenace82715693tenace
tepa66021683tepa__
tepal76319583tepa_l
tepals85415043tepals
tepas76521683tepa_s
thack144915173_thack
thwack1834213thwack
tieback1547103tieback
track114823013_track
trepan82511673trepa_n
trepang10257293trepang
trepans92311593trepans
tripacks1664893tripacks
umiack1435173umiack
unpacks1576093unpacks
unpick1446903unpick
untack1239763untack
wack135330913__wack
weak117126303we_a_k
wetback1875613wetback
whack174813023_whack
wrack145413883_wrack
wreak125513273wre_a_k
wreck144611043wre__ck
yack135425973__yack
yapock17365383yapock
zebeck23255203zebeck

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 Filter1786911127160.1401276364.3
2DLD Change Limit1127164206.58017130.1
3Display Results4204200.1233414.6
 (SQL Overall)1786914206.84326113.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.