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

169 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
recoilers1131815(None) 
recoiler103210491recoiler_
coilers93619902__coilers
recallers1137102recallers
receivers1436362receivers
reciters102613112rec_iters
recliners11279112recliners
recoiled113613212recoile_d
recoilless1242712recoilless
recoils93814872recoil__s
recolors1078812reco_lors
reconcilers1543422reconcilers
reconfers1437212reconfers
recorders12187952recorders
recovers133511122reco_vers
recyclers1642972recyclers
rejoicers18324242rejoicers
rerollers9207122rerollers
retailers9258772retailers
revilers114011692re_vilers
befoulers1443123befoulers
beguilers1252883beguilers
bewailers1434233bewailers
boilers93417063__boilers
broilers103210093_broilers
ceilers93912533__ceilers
coalers94419353__coalers
coiler84421593__coiler_
coiners93620753__coiners
coolers93522493__coolers
deceivers1535723deceivers
deciders123510753dec_iders
deciles104417723dec_ile_s
decliners12358613decliners
decoders122810413deco_ders
decolors1187713deco_lors
decouplers1573083decouplers
decoyers14287713deco_yers
decriers11299733decri_ers
defilers12439473de_filers
despoilers1343533despoilers
detailers10257253detailers
eloiners8128153_eloiners
etoiles7411293_etoile_s
exilers14419733_e_xilers
hecklers17357123hec_klers
moilers93615203__moilers
oilers64721193___oilers
pencilers1345643pencilers
peoplers1237163pe_oplers
precookers1843063precookers
prevailers15123833prevailers
railers74420663r__ailers
realisers9248323realisers
realizers18237933realizers
reboiled11349393reboile_d
reboils94111723reboil__s
recaller1039323recaller_
recamiers1345513recamiers
recanters112310483recanters
receiver1337413receiver_
receives1339743receive_s
recipes113314463rec_ipe_s
reciter94117263rec_iter_
recites93524583rec_ite_s
reckless14257973rec_kless
reckoners1545113reckoners
reclaimers1443593reclaimers
recliner103211913recliner_
reclines103718543recline_s
recoaled113111783recoale_d
recoals94214623recoal__s
recodes102918633reco_de_s
recognizers2353213recognizers
recoil84016723recoil___
recoiling121412413recoiling
recoined113614423recoine_d
recoins94019243recoi__ns
recollect1345703recollect
recollects1443683recollects
recolor978693reco_lor_
recompiles1645063recompile_s
reconciler1444693reconciler_
reconciles1447063reconcile_s
reconfer1337673reconfer_
reconquers2193353reconquers
reconsiders1443183reconsiders
reconvert1449473reconvert
reconverts1545723reconverts
reconveys1743533reconveys
recopies12313733recopie_s
recorder11249633recorder_
recounters1246213recounters
recouples13116823recouple_s
recover124312623reco_ver_
recoverers15133613recoverers
recovery16366213reco_very
recruiters1243713recruiters
rectifiers1545173rectifiers
recycler1543683recycler_
recycles1535353recycle_s
redliners10267853redliners
redoublers1342413redoublers
reelers73520273re__elers
refiles104122423re_file_s
refilters1236103re_filters
refiners114713313re_finers
reformers14246403reformers
regainers10237383regainers
regalers94311133re_galers
reifiers11309843reifi_ers
reivers105117083re__ivers
rejoicer17315343rejoicer_
rejoices17287663rejoice_s
rejoinders1843123rejoinders
reliers75519213re_li_ers
reloaders1036423reloaders
remodelers1342793remodelers
removers13449223remo_vers
rentiers83311763renti_ers
reoffers1434693re_offers
reoiled84316853re_oile_d
reoils64516873re_oil__s
reorders9198833re_orders
repairers1135283repairers
repealers11278843repealers
repellers11278883repellers
repiners103913433re_piners
repliers103710163repli_ers
reporters1139173reporters
reposers102911603repo_sers
repowers13288533repo_wers
reptiles103913063reptile_s
requirers18165003requirers
requiters18176553requiters
reroller8258753reroller_
resellers9299933resellers
residers93311883re_siders
resiles74026543re_sile_s
resilvers12306503re_silvers
resolders10258013resolders
resoles73823653reso_le_s
resolvers12297833resolvers
resorters939693resorters
retailer82911573retailer_
retailors9285363retailors
retainers92510763retainers
retiles74426993re_tile_s
retirers84311533re_tirers
retorters938773retorters
reuniters936423reuniters
revealers12318243revealers
revelers113414133re_velers
revellers12319513revellers
reviler104314973re_viler_
reviles104421353re_vile_s
revisers113511933re_visers
revivers14389633re_vivers
revoices13278993revoice_s
revokers15366753revo_kers
revolters12297483revolters
revolvers15286113revolvers
rewriters1236343rewriters
rollers73117473r__ollers
scowlers13257373_scowlers
seconders1236953seconders
spoilers10238633_spoilers
toilers74116263__toilers
veilers103911823ve__ilers

Search took 10 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 Limit1486411698.57617332.2
3Display Results1691690.0802112.5
 (SQL Overall)1786911699.06219718.7
 
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.