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

148 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
repairers113528(None) 
repairer1036781repairer_
despairers1343102despairers
impairers1343712impairers
preparers13197672prepa_rers
rearers74323562re_a_rers
regainers10237382regainers
repaired1148952repaire_d
repairs9319972repai__rs
repapers1258832repa_pers
repiners103913432rep_iners
repliers103710162repli_ers
requirers18165002requirers
retailers9258772retailers
retainers92510762retainers
retirers84311532re_tirers
airers64922313___airers
aspirers1066493asp_irers
bearers94619593be_a_rers
bewailers1434233bewailers
deplorers1245463deplorers
deprivers1545213deprivers
desirers939263de_sirers
despairer1243693despairer_
detailers10257253detailers
detainers10269103detainers
epimers11109493_ep_imers
expirers1735123_expirers
fearers104815273fe_a_rers
hearers104319783he_a_rers
impairer1244863impairer_
parers85530743__pa_rers
pepperers1244903pepperers
peptizers22245033peptizers
preparer12169643prepa_rer_
prepares122014163prepa_re_s
prevailers15123833prevailers
raiders84615143r__aiders
railers74420663r__ailers
raisers73617393r__aisers
rapiers95012873rap_i_ers
reachers133515723re_achers
readers83823773re_a_ders
realisers9248323realisers
realizers18237933realizers
realters83614043re_alters
reamers94221083re_a_mers
reapers93520453re_a_pers
rearer64928913re_a_rer_
reavers108320743re_a_vers
rebaters103413943reba_ters
recallers1137103recallers
recamiers1345513recamiers
recanters112310483recanters
receivers1436363receivers
reciters102613113re_citers
reclaimers1443593reclaimers
recliners11279113recliners
recoilers11318153recoilers
redbaiters1343603redbaiters
redliners10267853redliners
referrers12125373referrers
refiners114713313re_finers
refires104820313re_fire_s
refrainers1344473refrainers
regainer9249353regainer_
regalers94311133rega_lers
regathers1336353regathers
rehabbers1683133rehabbers
rehammers1644503rehammers
rehires105016113re_hire_s
reifiers11309843reifi_ers
reivers105117083re__ivers
rejoicers18324243rejoicers
relapsers1164123relapsers
relaters83218153rela_ters
relaxers15298263rela_xers
reliers75519213re_li_ers
remainders1354023remainders
remakers143811303rema_kers
remarkers15197283remarkers
remasters11310583remasters
renderers10208093renderers
rentiers83311763renti_ers
repaints1038483repai_nts
repair84011463repai__r_
repairing12310013repairing
repairman1342313repairman
repairmen1343333repairmen
repanels1036783repa_nels
repaper11310023repa_per_
reparks13249513repa_r_ks
repartees1147253repartees
repasses101810373repasse_s
repattern1143663repattern
repatterns1242493repatterns
repaves123513653repa_ve_s
repealers11278843repealers
repeaters112811993repeaters
repellers11278873repellers
repenters112511553repenters
repiner94816903rep_iner_
repines94927383rep_ine_s
replacers13266833replacers
replasters1245533replasters
replier94214973repli_er_
replies94521043repli_e_s
reporters1139173reporters
reposers102911603rep_osers
repowers13288533rep_owers
repress92712683rep__ress
reprices122913353reprice_s
reprinters1295793reprinters
reprises102615463reprise_s
reprovers14217773reprovers
reptiles103913063reptile_s
repulsers1144713repulsers
requirer17156113requirer_
requires17168703require_s
requiters18176553requiters
reraises8415643reraise_s
residers93311883re_siders
respires10311903respire_s
restorers95110113restorers
retailer82911573retailer_
retailors9285363retailors
retainer82913813retainer_
retakers123511133reta_kers
retarders10227573retarders
retirees84611653re_tirees
retirer74715013re_tirer_
retires74726213re_tire_s
reuniters936423reuniters
revampers1653443revampers
reverers113113153re_verers
revilers114011693re_vilers
revisers113511933re_visers
revivers14389633re_vivers
rewarders13226453rewarders
rewires104717113re_wire_s
rewriters1236343rewriters
roarers73812743r_oa_rers
sparers94519613_spa_rers
spearers103711143spea_rers
tearers75218233te_a_rers
trepanners1243083trepanners
unhairers12183273unhairers
wearers104615903we_a_rers

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 Filter1786911486410.423422437.4
2DLD Change Limit1486411486.89021573.4
3Display Results1481480.0632349.2
 (SQL Overall)1786911487.37624226.0
 
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.