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

151 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
readorns93827(None) 
readorn8310461readorn_
adorns74212612__adorns
radons74118522r_ado_ns
readers83823762reader_s
readopts1146482readopts
readorned1145182readorned
readouts938882readouts
reasons72514942reaso_ns
redons75222182re_do_ns
acorns85013013__acorns
adores74420713__adores
adorn64917093__adorn_
beacons11410733beaco_ns
beaders104120183beader_s
beadworks1945723beadworks
bethorns1337323bethorns
bradoons1136753bradoons
breakdowns2051863breakdowns
celadons1137003celado_ns
chadors1338723chador_s
creators102814383creator_s
deacons10310393deaco_ns
deadens93410693dead_ens
deadpans12205173deadpans
dehorns11428363de_horns
dendrons1047393dendrons
earns55927563_ea__rns
fedoras1137923fe_doras
hadrons113314303_hadrons
headers113819393header_s
headpins1436103headpins
headwords1745343headwords
headworks2045953headworks
ladrons83813193_ladrons
leadens83610983lead_ens
leaders83819603leader_s
leadoffs1542303leadoffs
leadworks1745123leadworks
leadworts1344733leadworts
learns65513743lea__rns
leghorns1244903leghorns
letdowns1243483letdowns
meadows1337333meado_ws
newborns1343383newborns
preadopts1445123preadopts
racons84319343r_aco_ns
racoons93912433r_acoons
radars71314663r_adar_s
radians83013823r_adians
radomes10311043r_adomes
radon64620503r_ado_n_
ratoons73815473r_atoons
rayons94113343r_ayo_ns
razors154711653r_azor_s
reabsorbs1342693reabsorbs
reactors103212283reactor_s
readapts1145583readapts
readding11411363readding
readdress1143823readdress
readds84111643read__ds
reader73628293reader__
readerly1245083readerly
readies83324703read_ies
reading93327213read_ing
readings103512633readings
readmits1136653readmits
readopt10410843reado_pt
readorning1245723readorning
readout8615493reado_ut
reads64835273read___s
readying13410223readying
reagins84215643rea_gins
realigns936253realigns
realtors82811683realtor_s
reamers94221083reamer_s
reanoint8413013reanoint
reanoints945363reanoints
reapers93520453reaper_s
rearers74323563rearer_s
rearms85114653rea__rms
rears54739653rea__r_s
reason62616333reaso_n_
reassorts945623reassorts
reavers108320743reaver_s
reavows1335273reavo_ws
rebores95319163re_bores
reborn810016953re_born_
reckons13269653recko_ns
recoins94019243re_coins
recons84922993re_co_ns
records105213923re_cords
recorks134813023re_corks
recrowns13246143recrowns
rectors93520513rector_s
redans75421023re_d_ans
reddens9259783re_ddens
redders93615343redder_s
redfins1139923re_dfins
redocks14409933re_docks
redoes74623753re_do_es
redoing93516733re_doing
redon65424883re_do_n_
redone74820053re_do_ne
redos65126763re_do__s
redound968173re_dound
redounds1055963re_dounds
redouts81411653re_douts
redowas1138393re_dowas
redoxes15310883re_doxes
reearns749103re_earns
reforms1239813re_forms
regions83613473regio_ns
rejoins143111383re_joins
relators83316113relator_s
relearns836303relearns
reloans7313133re_loans
remoras9314073re_moras
renders83821673render_s
renowns10277833re_nowns
reports94916213re_ports
rescores105415693rescores
resorbs95010523re_sorbs
resorts74817193re_sorts
restores85222983restores
retorn610923423re_torn_
retorts76016513re_torts
returns79712593re_turns
rewords115413973re_words
reworks145113593re_works
reworn98122193re_worn_
rhodoras1244453rhodoras
rigadoons1142623rigadoons
roadworks1745293roadworks
rubdowns1473073rubdowns
rundowns1284523rundowns
seaborne1055423seaborne
seadogs958643seado_gs
seaports1038463seaports
seasons72614233seaso_ns
teardowns1343043teardowns
tendons8311473tendo_ns
toreadors1045133toreador_s
treaders93311833treader_s
treasons848673treaso_ns
vendors113510223vendor_s
weakons14287803weako_ns
weapons12278603weapo_ns
weasons102310583weaso_ns
weldors11238003weldor_s
yearns9509543yea__rns

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 Filter1786911461620.1561145455.1
2DLD Change Limit1461621518.56317069.0
3Display Results1511510.0632396.8
 (SQL Overall)1786911518.78220347.4
 
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.