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

118 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
rerollers920712(None) 
reroller8258751reroller_
carollers1137702carollers
enrollers976172enrollers
recallers1137102recallers
recoilers11318152recoilers
repellers11278872repellers
rerolled93010052rerolle_d
rerolls739942reroll__s
resellers9299902resellers
resolders10258012resolders
resolvers12297832resolvers
revellers12319502revellers
revolters12297482revolters
revolvers15286112revolvers
rollers73117472__rollers
strollers937542strollers
trollers83211212_trollers
befoulers1443123befoulers
beholders1544933beholders
bevellers14276113bevellers
broilers103210093_broilers
carolers103314173caro_lers
caroller1039203caroller_
crullers1047303_crullers
drillers9429723_drillers
droller84110283_droller_
drollery12314793_drollery
enrollees974323enrollees
enroller867183enroller_
errorless942813errorless
evolvers14264773_evolvers
extollers1663843extollers
fellers104117543fe__llers
frillers11349873_frillers
frivollers1642073frivollers
girolles935523girolle_s
grillers93810813_grillers
growlers12327093_growlers
hellers103619833he__llers
hollers103818233__hollers
jewellers1943533jewellers
knollers12255143_knollers
krullers1234133_krullers
levellers12286043levellers
logrollers1142223logrollers
lollers72713793__lollers
patrollers1244813patrollers
pedallers1244763pedallers
peoplers1237163pe_oplers
pollers93420023__pollers
prowlers13328933_prowlers
ravellers12257163ravellers
realters83614043re_alters
recaller1039323recaller_
recoiler103210493recoiler_
recoilless1242713recoilless
recollect1345703recollect
recollects1443683recollects
recolors1078813reco_lors
reconfers1437213reconfers
recorders12187953recorders
recovers133511123reco_vers
recyclers1642973recyclers
redoublers1342413redoublers
reelers73520273re__elers
refilters1236103refilters
reflowers15125983reflowers
reformers14246403reformers
regalers94311133re_galers
rejoicers18324243rejoicers
reliers75519213re__liers
reloaders1036423reloaders
remodelers1342793remodelers
removers13449223remo_vers
reoffers1434693re_offers
reorders9198833re_orders
repealers11278843repealers
repeller103010393repeller_
repliers103710163re_pliers
repolled11359623repolle_d
repolls939053repoll__s
reporters1139173reporters
reposers102911603repo_sers
repowers13288533repo_wers
reprovers14217773repro_vers
repulsers1144713repulsers
reroll6412683reroll___
rerolling102210373rerolling
reroutes8312223reroute_s
reseller83412223reseller_
resilvers12306503resilvers
resolder9259233resolder_
resoles73823653reso_le_s
resolver11339793resolver_
resolves113010783resolve_s
resorters939693resorters
retailers9258773retailers
retorters938773retorters
revealers12318243revealers
revelers113414133re_velers
reveller112912183reveller_
revilers114011693re_vilers
revokers15366753revo_kers
revolter11279363revolter_
revolver14287713revolver_
revolves14278623revolve_s
rolfers104011813__rolfers
roller63919793__roller_
sellers73721313se__llers
stroller848173stroller_
tellers73717593te__llers
thrillers1244473thrillers
tollers73217463__tollers
trillers83613493_trillers
troller73913173_troller_
trolleys11315693_trolleys
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.423422437.4
2DLD Change Limit1486411188.06318434.9
3Display Results1181180.0462565.2
 (SQL Overall)1786911188.53220943.6
 
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.