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

112 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
reasoners94711(None) 
reasoner849341reasoner_
seasoners946261seasoners
reasoned9410732reasone_d
reasonless1043522reasonless
reasons72514942reason__s
reckoners1545112reckoners
seasoner857692seasoner_
atoners75013953__atoners
beckoners1744063beckoners
blazoners2043863blazoners
crayoners1444483crayoners
creasers103612813creas__ers
deaconess1245543deaconess
deadeners1146283deadeners
deboners11268113de_boners
earners74016453_ea_rners
easiness8313043_easiness
easters75125683_eas_ters
erasers74413943eras__ers
feasters11511563feas_ters
greasers93410253greas__ers
greasiness1156533greasiness
leaners73718173lea__ners
learners8398153lea_rners
leasers74717843leas__ers
meaners94415243mea__ners
measurers1144883measurers
peasoupers1492053peasoupers
pensioners1245363pensioners
poisoners1146113poisoners
prisoners1147373prisoners
ransomers1146873ransomers
rasers64526783r_as__ers
rashers104020903r_as_hers
rashness1138093r_ashness
raspers94415913r_as_pers
rasters74629023r_as_ters
ratooners965823ratooners
raveners11309123r_aveners
reachers133515723rea_chers
readers83823763rea__ders
readiness102611853readiness
realisers9248323realisers
realizers18237933realizers
realness8410443rea_lness
realters83614043rea_lters
reamers94221083rea__mers
reapers93520453rea__pers
rearers74323563rea__rers
reascends1244283reascends
reascents1177393reascents
reason62616333reason___
reasoning10310203reasoning
reasonings1143653reasonings
reassert8313673reas_sert
reasserts945983reas_serts
reassess836513reas_sess
reassures937223reassures
reavers108320743rea__vers
reckoner1446063reckoner_
recliners11279113recliners
reconfers1437213re_confers
recovers133511123re_covers
redbones1137593redbone_s
redliners10267853redliners
refiners114713313re_finers
reflowers15125983reflowers
regainers10237383regainers
reissuers954033reissuers
remasters11310583remas_ters
removers13449223re_movers
repiners103913433re_piners
reposers102911603re_posers
repowers13288533re_powers
reprovers14217773reprovers
rescuers1037363re_scuers
reshowers15145473reshowers
residers93311883re_siders
resigners1036863resigners
resojets1535343re_sojets
resolders10258013re_solders
resoles73823653re_sole_s
resolvers12297833re_solvers
resorters939683re_sorters
responders1345773responders
resters74130403re_s_ters
restorers95110113restorers
resumers1038083re_sumers
retainers92510763retainers
returners9376553returners
revokers15366753re_vokers
rezones163213943re_zone_s
roasters83615913roas_ters
seasonals945283seasonals
seasoned948113seasone_d
seasonless1043373seasonless
seasons72614233season__s
teaselers9165843teaselers
teasers75317243teas__ers
tenoners858703te_noners
tensioners1044823tensioners
treasonous1052683treasonous
treasons848673treason__s
treasurers1043203treasurers
wagoners1235463_wagoners
weakeners1644163weakeners
weaners104613833wea__ners
weaponeers1542003weaponeers
weasons102310583weason__s
yearners11346373yea_rners
yeasayers1542023yeasayers

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.1701051123.5
2DLD Change Limit1486411129.22016121.6
3Display Results1121120.0462434.8
 (SQL Overall)1786911129.43618937.2
 
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.