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

233 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
recanters11231048(None) 
decanters12229221decanters
recanter101913151recanter_
canters94827732__canters
decanter112510792decanter_
decenters122410372decenters
descanters1345012descanters
levanters1254992levanters
precancers1645252precancers
ranters73323642r__anters
realters83614042re_alters
rebaters103413942reba_ters
recallers1137102recallers
recamiers1345512recamiers
recanes93222262recan_e_s
recanted112513512recante_d
recants93217092recant__s
recenter102715442recenter_
recharters1555422recharters
reciters102613112rec_iters
reconfers1437212reconfers
recounters1246212recounters
reenters82915302re_enters
reinters82614772re_inters
relaters83218152rela_ters
remasters11310582remasters
renters74224812re__nters
repenters112511552repenters
banters94623113__banters
beaters94925043be_a_ters
betatters1134963betatters
cancers114018583__cancers
caners84629203__can_ers
cankers134418753__cankers
canners93822663__canners
canoers94318373__canoers
canter85230113__canter_
cantors94620753__cantors
carters95327253__carters
casters94729903__casters
caters85336503__ca_ters
cementers1338313cementers
centers94420603__centers
chanters134016743_chanters
debaters113511923deba_ters
decaliters1345213decaliters
decameters15156593decameters
decanes103118913decan_e_s
decanted122310493decante_d
decants103514443decant__s
decayers14307963deca_yers
decenter112412163decenter_
decentres12238523decentres
demanders13247573demanders
derangers1136703derangers
desalters1037673desalters
descanter1246443descanter_
dewaters122910723dewa_ters
easters75125683_e_asters
eaters65535953_e_a_ters
ecartes94212563_ecarte_s
elaters74420193_ela_ters
enchanters1545223enchanters
enters64425643_e__nters
erecters102611613erec__ters
exacters1736773_exacters
exalters1536653_exalters
feasters11511563fe_asters
forecasters1675003forecasters
granters93614143_granters
heaters104225223he_a_ters
incenters112510303incenters
leaners73718173le_an_ers
levanter1145303levanter_
locaters102710073loca_ters
meanders1168833me_anders
meaners94415243me_an_ers
negaters9349783nega_ters
planters102915323_planters
prealters1147773pre_alters
precancels1644063precancels
precancer1547093precancer_
precentors1488343precentors
presenters1239863presenters
preventers1547393preventers
raconteurs1241843raconteurs
rafters103715633r__afters
rangers83621043r__angers
rankers113217463r__ankers
ranter63826823r__anter_
rasters74629023r__asters
raters63936583r__a_ters
ratters74422473r__atters
reachers133515723re_achers
reactors103212283re_actors
readers83823773re_a_ders
realter73716313re_alter_
realtors82811683re_altors
reamers94221083re_a_mers
reapers93520453re_a_pers
rearers74323563re_a_rers
reavers108320743re_a_vers
rebater93517913reba_ter_
rebates95123183reba_te_s
rebutters1195093rebutters
recaller1039323recaller_
recamier1237603recamier_
recane83022873recan_e__
recaned102817203recan_e_d
recant83228683recant___
recanting122414823recanting
recapture1384713recapture
recaptures1474463recaptures
recarpets1344383recarpets
recasts93413533recast__s
receivers1436363receivers
recensors1176133recensors
recentest11410283recentest
recentness1245463recentness
receptors1356923receptors
rechanges1568183rechange_s
rechannels1543183rechannels
rechargers1644103rechargers
recharter1466893recharter_
reciter94117263rec_iter_
recites93524583rec_ite_s
reckoners1545113reckoners
reclaimers1443593reclaimers
recliners11279113recliners
recoilers11318153recoilers
reconfer1337673reconfer_
reconquers2193353reconquers
recontours1243463recontours
reconvert1449473reconvert
reconverts1545723reconverts
reconveys1743533reconveys
recorders12187953recorders
recounter1137943recounter_
recovers133511123rec_overs
recrates102420373recrate_s
recruiters1243713recruiters
rectors93520513rec__tors
recyclers1642973recyclers
redactors1247533redactors
redates83423873reda_te_s
redbaiters1343603redbaiters
reenter73217793re_enter_
refastens1244753refastens
refilters1236103refilters
refiners114713313refin_ers
refunders1334973refunders
refuters11449613re_futers
regainers10237383regainers
regalers94311133rega_lers
regathers1336353regathers
registers1038893registers
rehabbers1683133rehabbers
rehammers1644503rehammers
reheaters122010273reheaters
reinter73116843re_inter_
rejecters18257543rejecters
relapsers1164123relapsers
relater73723143rela_ter_
relates73731433rela_te_s
relators83316123rela_tors
relaunders1153103relaunders
relaxers15298263rela_xers
reletters9138783reletters
remainders1354023remainders
remakers143811303rema_kers
remarkers15197283remarkers
remaster10311473remaster_
remates93827113rema_te_s
reminders12308653reminders
remitters11328403remitters
rencontres1244383rencontres
rencounters1343303rencounters
renders83821673re__nders
renter64527413re__nter_
rentes65431193re__nte_s
rentiers83311763re__ntiers
repairers1135283repairers
repanels1036783repan_els
repapers1258833repa_pers
repartees1147253repartees
repattern1143663repattern
repatterns1242493repatterns
repeaters112811993repeaters
repenter102813863repenter_
repiners103913433repin_ers
replasters1245523replasters
reporters1139173reporters
reprinters1295793reprinters
requiters18176553requiters
rescinders1344303rescinders
resetters9129463resetters
resisters9310453resisters
resorters939693resorters
resters74130403re__sters
retailers9258773retailers
retainers92510763retainers
retakers123511133reta_kers
retarders10227573retarders
retastes82212903retaste_s
retorters938773retorters
reuniters936423reuniters
reutters8138573re_utters
revampers1653443revampers
revengers1336413revengers
revenuers1235983revenuers
reverters122710433reverters
revolters12297483revolters
rewarders13226453rewarders
rewinders13246503rewinders
rewriters1236343rewriters
roasters83615933r_oasters
rocketers15186883rocketers
romancers1345733romancers
scanners10379703_scanners
scanter94215183_scanter_
scatters103612753_scatters
seaters74028943se_a_ters
secants93413893secant__s
secateurs1142723seca_teurs
seconders1236953seconders
tenters73921103te__nters
treaters83615843tre_a_ters
trepanners1243083trepanners
trochanters1653433trochanters
venters103717733ve__nters
wanters104420093__wanters
weaners104613833we_an_ers
webcasters1742143webcasters

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.1561145455.1
2DLD Change Limit1486412337.12320867.8
3Display Results2332330.0962427.1
 (SQL Overall)1786912337.37524229.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.