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

471 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
repair8401146(None) 
repaid94716321repaid
repairs9319971repairs
deair65817192de_air
despair1045462despair
impair1036002impair
pair66031512__pair
prepaid12310132prepaid
reaper84223142reaper
rear45644552re_a_r
rebait8320402rebait
rebar75420192reba_r
regain74517762regain
relaid75518442relaid
remail85017122remail
remain85919862remain
renail65020762renail
repack142412162repack
repaint9318362repaint
repaired1148952repaired
repairer1036782repairer
repand95316062repand
repaper11310022repaper
repark123511712repark
repass84114702repass
repast83520632repast
repave114813872repave
repay104818452repa_y
repays113813972repays
repin75324702rep_in
replier94214972replier
repour8310992repour
resaid74517082resaid
resail64418732resail
retail65522072retail
retain64523282retain
unrepair1042372unrepair
affair1234353affair
air38058393___air
arepa75615563arepa__
arepas85515703arepa_s
bear66844643be_a_r
bepaint11312183bepaint
bestir8311163bestir
bewail1189583bewail
cedar84014323ceda_r
chair105519633_chair
crepier1139743crepier
deairs74013783de_airs
dear55343603de_a_r
debar85517863deba_r
denar65223293dena_r
denari710917353denari
depaint10314593depaint
depart94720563depart
derail74218813derail
despairs1144943despairs
detail74516433detail
detain74617383detain
devoir1076033devoir
dewar95817733dewa_r
diapir9357113diapir
disrepair12103343disrepair
drear65016903dre_a_r
ear36867883_e_a_r
eclair836813eclair
elain55324703_elain
email74715103_email
emir65918703_e_mir
epact94921533_epact
ephor10310013_ephor
epic86921303_ep_ic
erepsin937383erepsin
eyrir8359653_eyrir
fair76332523__fair
fear75337793fe_a_r
feuar8310243feua_r
flair86114123_flair
gear55934973ge_a_r
glair65313553_glair
hair76330143__hair
heaper114119523heaper
hear76143883he_a_r
hegari1039523hegari
heir77523803he__ir
heparin12410433heparin
hepatic141712773hepatic
hepper133412663hepper
hetaira1045903hetaira
impairs1135823impairs
jezail2234643jezail
kebar115113533keba_r
kefir12457913ke_fir
keir86217873ke__ir
kepi105315633kep_i_
kepis115313363kep_is
lair45934153__lair
leaper88118943leaper
lear47045953le_a_r
leper74820743lep_er
leptin82512333leptin
mair66133783__mair
memoir1037213memoir
menhir1136783menhir
midair937993midair
mohair1135203mohair
near45236503ne_a_r
paid75737483__paid
paik105726803__paik
pail66141833__pail
pain65647243__pain
pairs75325833__pairs
papain10313793papain
par57467023__pa_r
parr65731153__parr
pear69745233pe_a_r
pepper93512943pepper
peppier10268323peppier
pepsin10310853pepsin
peptic122113153peptic
peptid112712373peptid
prepack1757643prepack
prepare111913623prepare
preparer12169643preparer
prepave14228873prepave
prepay13310313prepa_y
prepays1437483prepays
preppie1058093preppie
preppier1156643preppier
prevail1238243prevail
prewar114712583prewa_r
radar61316723rada_r
rai37658223r__ai_
raia46638383r__aia
raid55243073r__aid
rail46147763r__ail
rain46251733r__ain
rais45252623r__ais
raper74932753rap_er
raphia113511263raphia
raphis114014323raphis
rapid86422033rap_id
rapier84019993rapier
rapper104621573rapper
raptor83912823raptor
reach105123883re_ach
react74634333re_act
read55942533re_a_d
readd74617133re_add
reader73628293reader
readier83117423readier
reads64835273re_ads
ready94821503re_ady
reagin74915533reagin
real45750293re_a_l
realer63528593realer
realia6314593realia
realm75621623re_alm
reals55038653re_als
ream65841613re_a_m
reamer84325213reamer
reams75729623re_ams
reap65934743re_a_p
reaped94122453reaped
reapers93520453reapers
reaping103621213reaping
reaps75626193re_aps
rearer64928913rearer
rearm75923573re_arm
rears54739653re_ars
reata54225393re_ata
reavail1035643reavail
reave84528023re_ave
reaver94524733reaver
rebaits9312573rebaits
rebars84019833rebars
rebate84424113rebate
rebater93517913rebater
rebato83714683rebato
rebid85121363re_bid
reboil83814683reboil
recall83815723recall
recamier1237603recamier
recane83022873recane
recant83228683recant
recap95718023reca_p
recaps103615733recaps
recarry1245063recarry
recast83422773recast
recit75235103re_cit
reclaim1137753reclaim
recoil84016723recoil
recoin84320293recoin
recti73619623recti_
rector84019753rector
recur74116843re_cur
redact9419043redact
redan66125013reda_n
redans75421023redans
redate74124683redate
redbait1039803redbait
redbird1155263redbird
redder83918143redder
redear73515173redear
redfin10310223redfin
redia65524483re_dia
rediae74221993rediae
redial74923113redial
redias74523603redias
redid74922393re_did
redip87816963re_dip
redtail858713redtail
reearn6612143reearn
reedier83815303reedier
reedit7617223reedit
reefer93314363reefer
reefier102912553reefier
reeker103715593reeker
reekier113111123reekier
reeler63822573reeler
reemit8717223reemit
reface113616353reface
refall94314393refall
refer84822143re_fer
refire95419473re_fire
refit84230063re_fit
refix155212483re_fix
refrain10310043refrain
regainer9249353regainer
regains84316583regains
regal65023793rega_l
regale74821453regale
regaler83814623regaler
regalia839223regalia
regard85215773regard
regave104713383regave
regear73512743regear
rehab10312443reha_b
rehabs1139023rehabs
rehang1039823rehang
rehash1237433rehash
rehear93713223rehear
rehire95415863re_hire
rei35647253re__i_
reif76937653re__if
reifier103414523reifier
rein46040893re__in
reis45343233re__is
reiver95318293reiver
rejig133810123re_jig
rejoin134012243rejoin
reknit10312533reknit
relace83122153relace
reland75920433reland
relate64033633relate
relater73723143relater
relator74016363relator
relax124817803rela_x
relaxer143410223relaxer
relaxin14239183relaxin
relay84424673rela_y
relays94316753relays
relic74623363re_lic
relier65826183relier
relit55340683re_lit
remade94316983remade
remails94714563remails
remains94117913remains
remake124016113remake
remaker133813173remaker
reman75730153rema_n
remand95618963remand
remans84823003remans
remap95418103rema_p
remaps105012873remaps
remark123512373remark
remarry1235193remarry
remate84428683remate
remit75737223re_mit
remix145916553re_mix
renails74917263renails
renal55929503rena_l
rename82718813rename
render74024143render
renig64518913re_nig
renin54830033re_nin
rennin63914033rennin
renter64527413renter
rentier73618223rentier
reoil55321183re_oil
rep55847803rep___
repacify1843483repacify
repacks15269543repacks
repaints1038483repaints
repairers1135283repairers
repairing12310013repairing
repairman1342313repairman
repairmen1343333repairmen
repanel939963repanel
repapers1258833repapers
reparks13249513reparks
repasts93611933repasts
repatch1435843repatch
repaved133311133repaved
repaves123513653repaves
repaving142810743repaving
repaying142712393repaying
repeal84718283repeal
repealer103210703repealer
repeals94014523repeals
repeat85127213repeat
repeater102615443repeater
repeats94316053repeats
repeg84015053rep_eg
repegs93311943repegs
repel74921403rep_el
repels84318763repels
repent84728873repent
reperk122511773reperk
repine85627813repine
repiner94816903repiner
repins84924313repins
replace113214283replace
replacer12279743replacer
replan83215823replan
replans92814943replans
replant93318533replant
replate93420053replate
replay113412923replay
replays12399763replays
repled93319783repled
replica1137943replica
replied103914453replied
repliers103710163repliers
replies94521043replies
replot83818593replot
replow114210343replow
reply104015853rep_ly
repo66027543rep__o
repoll8410793repoll
report85326023report
repos74725793rep_os
repose84121413repose
reposer93715333reposer
reposit9315863reposit
repot75132623rep_ot
repots85621003repots
repours9310233repours
repower12329883repower
repp85418743rep__p
repped114616723repped
repping123314983repping
repps95114343rep_ps
reprice113212833reprice
reprint9318983reprint
reprise92715043reprise
repro75315913rep_ro
repros84216003repros
reps65937953rep__s
reptant92817073reptant
reptile93914083reptile
repugn946493repugn
repump1235683repump
repute84716093repute
requin15310713requin
require16148653require
rerack122513163rerack
reraise7316313reraise
reran57329103rera_n
rerig64018483re_rig
resails74616743resails
resale64025543resale
resat55139683resa_t
resaw84117253resa_w
resawn9399953resawn
resaws93713513resaws
resay85320543resa_y
resays93714153resays
reship11310673reship
resid64124093re_sid
resin54131053re_sin
resit54241043re_sit
respace11310913respace
respade1039573respade
respire9411543respire
resplit9310373resplit
rester63832433rester
retack122612823retack
retag63618413reta_g
retags73414303retags
retailer82911573retailer
retailor8285223retailor
retails74718973retails
retainer82913813retainer
retains74522253retains
retake104718533retake
retaker113714313retaker
retape83917683retape
retard75018933retard
retax124517973reta_x
retear63115483retear
retia55326113re_tia
retial64724993retial
retiary1038333retiary
retie55735303re_tie
retire64927013re_tire
retrain7615423retrain
retrim83514883retrim
revamp1336013revamp
rewake135218463rewake
rewan85623663rewa_n
reward106017643reward
rewarm115913493rewarm
rewash1237673rewash
rewax155713923rewa_x
rewear93012003rewear
rewin85623963re_win
rewire95421413re_wire
riper74328403rip_er
ripper103518653ripper
roar46328573r_oa_r
roper75431913rop_er
ropier84118803ropier
rupiah1146213rupiah
sear47353843se_a_r
secpar1037923secpa_r
sepal77723003sepa_l
sepals85217373sepals
sepia75318673sep_ia
sepias83616103sepias
sepic94617053sep_ic
sepsis83011293sepsis
septic102713193septic
serai56830163serai_
serail64222673serail
serais64326133serais
sewar85421103sewa_r
spail74921553_spail
spait75631603_spait
spar65433303_spa_r
spear75821063spea_r
speir75315363_speir
stair54719943_stair
tapir75917063tap_ir
tear45242883te_a_r
tenail64516113tenail
tepa66021683tepa__
tepal76319583tepa_l
tepals85415043tepals
tepas76521683tepa_s
tepid8314313tep_id
terai53525483terai_
terais64023513terais
trenail7410813trenail
trepan82511673trepa_n
trepang10257293trepang
trepans92311593trepans
trepid9310083trep_id
unfair936233unfair
unhair937333unhair
unpaid939473unpaid
unrepaid1143713unrepaid
unrepairs1142043unrepairs
vair75624143__vair
velar85817633vela_r
wair75830053__wair
wear75836723we_a_r
weir76019923we__ir
wirehair1443343wirehair
year76534253ye_a_r
zephyr2342083zephyr

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.373479064.3
2DLD Change Limit1127164715.90619085.0
3Display Results4714710.1563019.2
 (SQL Overall)1786914716.43527768.6
 
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.