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 “rainouts” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

89 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
rainouts84691(None) 
rainout7314391rainout_
bailouts1036612bailouts
ragouts838542ra_gouts
raincoats1144062raincoats
rainspouts1252062rainspouts
ruinous739762ruinou_s
runouts737352r_unouts
spinouts1036022spinouts
acinous9310933acinou_s
adnouns835453_adnouns
arenous7314183arenou_s
backouts1698643backouts
bailout9414133bailout_
brownouts1443113brownouts
burnouts1045263burnouts
campouts1436823campouts
dimouts1037893_dimouts
fadeouts1245693fadeouts
faints94818783fain__ts
faitours1134263faitours
fallouts1137883fallouts
grayouts1244693gra_youts
haints94417583hain__ts
haircuts1343663haircuts
handouts1238233handouts
hangouts1236183hangouts
heinous1038853heinou_s
inputs837703__inputs
kainits1137763kain_its
knouts10438313__knouts
laminous1037953laminou_s
layouts1046483la_youts
linocuts1094573_linocuts
mahouts1237143ma_houts
ominous949033ominou_s
paints85921833pain__ts
payouts1247303pa_youts
pigouts1037593_pigouts
pinots85920273_pino_ts
printouts1143763printouts
ragout7317183ra_gout_
ragworts12125803ragworts
railbus934413railbu_s
raiments1039903raiments
rainbows1343243rainbows
raincoat1046633raincoat_
rainiest81214923rainiest
rainless8129703rainless
rains55140233rain___s
rainspout1153913rainspout_
ramous8417113ra_mou_s
rancours1076713rancours
rants55935343ra_n__ts
rapports1245963rapports
raucous938303raucou_s
ravenous1146793ravenou_s
readouts938903readouts
redouts81411663r_edouts
reincurs1045553reincurs
reinducts1284313reinducts
reknots1136783rekno_ts
resinous838503resinou_s
rhinos94411123rhino__s
rigours8207003r_igours
rimous8311913r_imou_s
riots54922013r_i_o_ts
riposts9279403r_iposts
rollouts8136733rollouts
rosinous847373rosinou_s
routs57133413r___outs
rubouts937983r_ubouts
runout6414873r_unout_
saints65122423sain__ts
sanious7514103saniou_s
slipouts1044893slipouts
snouts64915873__snouts
spinous9310443spinou_s
spinout9311583spinout_
taints64520533tain__ts
takeouts1245363takeouts
trainfuls1243953trainfuls
turnouts845413turnouts
uranous7310733ura_nou_s
urinous7310083urinou_s
vinous93914173_vinou_s
walkouts1544253walkouts
walnuts1033843waln_uts
washouts1445903washouts

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 Filter1786911461620.423422437.4
2DLD Change Limit146162896.87321266.1
3Display Results89890.0332697.0
 (SQL Overall)178691897.32924381.4
 
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.