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

270 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
repairing1231001(None) 
deairing10311892de_airing
despairing1445062despairing
impairing1445472impairing
pairing103716732__pairing
preparing14311642prepa_ring
rearing83128782re_a_ring
rebaiting12311642rebaiting
refiring123513922re_firing
regaining112411082regaining
rehiring122911882re_hiring
remailing122412472remailing
remaining122212792remaining
renailing102813332renailing
repacking1838282repacking
repainting13128972repainting
repapering1547042repapering
reparking1638922reparking
repassing12249422repassing
repasting122312842repasting
repaving142810742repa_ving
repaying142712392repa_ying
repining114116592rep_ining
repouring12310072repouring
repricing14310472repricing
reprising12312552reprising
requiring1937042requiring
reraising10313772reraising
resailing103314252resailing
respiring12159902respiring
retailing103214732retailing
retaining102114732retaining
retiring92717412re_tiring
rewiring122911222re_wiring
airing74927503___airing
aspiring1138873asp_iring
bearing103624773be_a_ring
bemiring13239603be_miring
bepainting15144883bepainting
bewailing1536063bewailing
bewaring14279493bewa_ring
chairing143110773_chairing
debarring1335713debarring
depainting14156153depainting
departing1349513departing
deploring1337853deploring
depriving1636403depriving
derailing112011313derailing
desiring10312143de_siring
detailing112510413detailing
detaining112510473detaining
earing75235483_e_a_ring
earring83519013_e_arring
emailing113010043_emailing
expiring1836253_expiring
fairing113614013__fairing
fearing113520033fe_a_ring
gearing92818843ge_a_ring
glairing1047283_glairing
hearing113324163he_a_ring
heiring113312903he__iring
heparin12410433hepa_rin_
heparins13310123hepa_rins
hepatizing2546823hepatizing
lairing83715343__lairing
nearing83020333ne_a_ring
paiking143814813__paiking
paining103920243__paining
pairings11398313__pairings
paring94236493__pa_ring
parring103222063__parring
peppering1337083peppering
peptizing2347113peptizing
prefiring1559073pre_firing
prehiring1548383pre_hiring
prepacking2145773prepacking
prepasting15168883prepasting
prepaving1787233prepa_ving
prepaying1747973prepa_ying
prepricing1746733prepricing
prevailing1656723prevailing
prewiring1547893pre_wiring
raiding93617593r__aiding
railing83325643r__ailing
raining83922693r__aining
raising83220533r__aising
rapturing1245353rapturing
raring74332873r__a_ring
reaching143317203re_aching
reacting113317893re_acting
readding11411363re_adding
reading93327213re_a_ding
readying13410223re_adying
realising10313173realising
realizing19313813realizing
reaming103924013re_a_ming
reaping103621213re_a_ping
rearming111413613re_arming
reavailing1444873reavailing
reaving113820533re_a_ving
rebating112418343reba_ting
reboiling12149823reboiling
reboring11312783re_boring
recalling122211903recalling
recaning111416693reca_ning
recanting122414823recanting
recapping1636453recapping
recarrying1643653recarrying
recasting122414233recasting
receiving1538993receiving
reciting113118073re_citing
reclaiming1546583reclaiming
reclining121112283reclining
recoiling121412413recoiling
recoining121313803recoining
recurring1237953recurring
redacting13612303redacting
redating102620173reda_ting
redbaiting1446263redbaiting
redialing11311843redialing
redlining111210293redlining
redriving1437603redriving
reearning1039053reearning
reediting11310953reediting
refacing142512813refa_cing
refalling132010423refalling
referring1338033referring
refiling123116533re_filing
refining122416863re_fining
refixing19329793re_fixing
refraining1437263refraining
regaling10315363rega_ling
regarding12149153regarding
regauging1235543regauging
regearing112211413regearing
regiving13269713re_giving
rehabbing1733653rehabbing
rehanging1437563rehanging
rehashing1647113rehashing
rehearing132211763rehearing
reining84425323re__ining
reiving113316843re__iving
rejoicing19136943rejoicing
rejoining17149223rejoining
relacing112516043rela_cing
relanding112110923relanding
relapsing1236843relapsing
relating92725443rela_ting
relaxing162612633rela_xing
relaying122515153rela_ying
relining93218743re_lining
reliving122713343re_living
remaking152613303rema_king
remanding132211143remanding
remanning12229033remanning
remapping1635023remapping
remarking1638893remarking
remarrying1643373remarrying
remating112322413rema_ting
remising112516453re_mising
remixing182810333re_mixing
renaming11313693rena_ming
renaturing11176803renaturing
rendering112213183rendering
reoiling93217213re_oiling
repacifying2243543repacifying
repaint9318363repa__int
repair84011463repair___
repaired1148953repair_ed
repairer1036783repair_er
repairers1135283repairers
repairman1342313repairman
repairmen1343333repairmen
repairs9319973repair__s
repaneling1345733repaneling
repatching1844993repatching
repealing122513543repealing
repeating122618983repeating
repegging1435593repegging
repelling122312753repelling
repenting122316553repenting
reperking1638703reperking
repinning12258973repinning
replacing142210163replacing
replanning1345313replanning
replanting1338523replanting
replating122217403replating
replaying15259603replaying
replowing1537413replowing
replying14269403rep_lying
repolling122110203repolling
reporting12513903reporting
reposing111213803rep_osing
repositing13310493repositing
repotting12511123repotting
repowering1645273repowering
repping123314983rep__ping
reprieving1644893reprieving
reprint9318983rep__rint
reprinting131510583reprinting
reprobing1438073reprobing
reproving1538413reproving
repugning1335863repugning
repulsing1237613repulsing
repumping1634813repumping
reputing112412603rep_uting
requiting1939883requiting
reracking1639313reracking
rerising93017783re_rising
resawing122311433resa_wing
resaying122512453resa_ying
rescoring12310603rescoring
reseizing19311233reseizing
reshining13310743reshining
residing103015473re_siding
resiling93520173re_siling
resining92919553re_sining
resiting93521123re_siting
resizing182714163re_sizing
respacing1438893respa_cing
respading1338803respa_ding
respiting121912863respiting
resplicing1546293resplicing
respring111614063re_spring
restoring10314613restoring
restring91518783re_string
retacking1658973retacking
retagging1236033retagging
retailings11265233retailings
retailoring1243733retailoring
retaking133114283reta_king
retaping113012553reta_ping
retarding111110653retarding
retasting102513413retasting
retaxing162311333reta_xing
retearing102214253retearing
retieing92913713re_tieing
retiling93319483re_tiling
retiming113014193re_timing
retraining11310243retraining
reuniting10310693reuniting
revaluing1337303revaluing
revamping1734633revamping
revering122918073re_vering
reviling122917213re_viling
revising122714403re_vising
reviving152910503re_viving
revoicing15117713revoicing
rewaking162310983rewa_king
rewarding14148833rewarding
rewarming15147383rewarming
rewashing1676903rewashing
rewaxing19248563rewa_xing
rewearing132310703rewearing
rewriting13310413rewriting
roaring82916003r_oa_ring
rupturing1244353rupturing
searing83330923se_a_ring
sparing104823873_spa_ring
sparring113112223_sparring
spearing113216103spea_ring
speiring113711263_speiring
spiring103918183_sp_iring
tearing84021493te_a_ring
trepanning1344153trepanning
trephining1644933trephining
umpiring1336093ump_iring
unhairing1335953unhairing
wairing113414313__wairing
wearing113318863we_a_ring

Search took 9 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 Filter1786911486410.406440125.6
2DLD Change Limit1486412707.64019455.6
3Display Results2702700.1262142.9
 (SQL Overall)1786912708.17221866.3
 
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.