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

164 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
recallers113710(None) 
recaller1039321recaller_
callers94221962__callers
pedallers1244762pedallers
realters83614042re_alters
recalled11310802recalle_d
recalls92613622recall__s
recamiers1345512recamiers
recanters112310482recanters
recoilers11318152recoilers
recyclers1642972recyclers
regalers94311132rega_lers
repellers11278872repellers
rerollers9207122rerollers
resellers9299902resellers
retailers9258772retailers
revellers12319502revellers
ballers94421013__ballers
bevellers14276113bevellers
bewailers1434233bewailers
cablers114416713__cablers
calkers134414693__calkers
callees94117783__callees
caller85125483__caller_
callets93821703__callets
canallers1137213canallers
catcallers1443803catcallers
crevalles1455723crevalle_s
cullers93418853__cullers
dealers84118613de_a_lers
decaliters1345213decaliters
decanters12229223decanters
decayers14307963deca_yers
decayless1542863decayless
declarers1236423declarers
desalters1037673desalters
detailers10257253detailers
diallers957773_diallers
enablers10196913_enablers
exalters1536653_exalters
fallers103917993__fallers
fellers104117543fe__llers
fireballers16132503fireballers
healers104319463he_a_lers
hecklers17357123hec_klers
hellers103619833he__llers
jewellers1943533jewellers
levellers12286043levellers
mealless10288363me_alless
miscallers1444303miscallers
pearlers1039033pe_arlers
pedalers11239393peda_lers
pedalfers1542903pedalfers
pedaliers1245183pedaliers
pedaller1136093pedaller_
pencillers1443823pencillers
prealters1147773pre_alters
precancers1645253precancers
prevailers15123833prevailers
railers74420663r__ailers
ralliers84010833r__alliers
ravellers12257163ravellers
reachers133515723re_achers
readers83823773re_a_ders
realer63528593re_a_ler_
reales64934123re_a_le_s
realgars934533re_algars
realisers9248323re_alisers
realizers18237933re_alizers
reallots837993re_allots
realness8410443re_alness
realter73716313re_alter_
realtors82811683re_altors
reamers94221083re_a_mers
reapers93520453re_a_pers
rearers74323563re_a_rers
reavers108320743re_a_vers
rebaters103413943reba_ters
recall83815723recall___
recalling122211903recalling
recamier1237603recamier_
recanes93222263reca_ne_s
recanter101913153recanter_
recarpets1344383recarpets
receivers1436363receivers
rechargers1644103rechargers
recharters1555423recharters
reciters102613113rec_iters
reckless14257973rec_kless
reckoners1545113reckoners
reclaimers1443593reclaimers
reclames12310893reclame_s
recliners11279113recliners
recoiler103210493recoiler_
recoilless1242713recoilless
recollect1345703recollect
recollects1443683recollects
recolors1078813rec_olors
reconfers1437213reconfers
recorders12187953recorders
recovers133511123rec_overs
recycler1543683recycler_
recycles1535353recycle_s
reelers73520273re__elers
refallen1136213refalle_n
refalls103312243refall__s
refilters1236103refilters
regainers10237383regainers
regaler83814623rega_ler_
regales83520793rega_le_s
regalness1045473regalness
regathers1336353regathers
rehabbers1683133rehabbers
rehammers1644503rehammers
relapsers1164123relapsers
relaters83218153rela_ters
relaxers15298263rela_xers
reliers75519213re__liers
remakers143811303rema_kers
remarkers15197283remarkers
remasters11310583remasters
repairers1135283repairers
repapers1258833repa_pers
repealers11278843repealers
repeller103010393repeller_
replacers13266833replacers
repliers103710163re_pliers
repulsers1144713repulsers
reroller8258753reroller_
resales74724903resa_le_s
rescales103414573resca_le_s
reseller83412223reseller_
resilvers12306503resilvers
resolders10258013resolders
resolvers12297833resolvers
retables101712673retable_s
retailer82911573retailer_
retailors9285353retailors
retainers92510763retainers
retakers123511133reta_kers
retallies939353retallies
retarders10227573retarders
revalues1137883revalue_s
revampers1653443revampers
revealers12318243revealers
revelers113414133re_velers
reveller112912183reveller_
revilers114011693re_vilers
revolters12297483revolters
revolvers15286113revolvers
rewarders13226453rewarders
rocailles1144993rocaille_s
rollers73117473r__ollers
scalers93817263_sca_lers
scalpers123710863_scalpers
scullers103510483_scullers
sealers74323553se_a_lers
sellers73721313se__llers
spallers102910733_spallers
squallers1834683squallers
tellers73717593te__llers
treadlers1045893tre_adlers
vealers103214293ve_a_lers
yellers103912953ye__llers

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.1701051123.5
2DLD Change Limit1486411647.76619140.0
3Display Results1641640.0802050.0
 (SQL Overall)1786911648.01622291.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.