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

93 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
ratooner88700(None) 
ratooned977101ratooned
ratooners965831ratooners
atoner64817192_at_oner
rationed9410092rationed
ratoon64417372ratoon__
ratoons73815472ratoon_s
rattener8238532rattener
rattooned1043842rattooned
actioner1048663actioner
adorner8246983_adorner
almoner949383_almoner
atone56527983_at_one_
atoned75417543_at_oned
atoners75013953_at_oners
atones65225773_at_ones
baboonery1642333baboonery
battener10369393battener
buttoner1036973buttoner
cartooned1246313cartooned
cautioner1145393cautioner
crayoner1344863cra_yoner
crooner93714043_crooner
dragooned1242963dragooned
falconer1346033falconer
fathomer1645293fathomer
fattener11268113fattener
gammoner1345153gammoner
harpooner1444333harpooner
intoner7811673int_oner
jawboner20133363jawboner
lampooner1343363lampooner
lateener835763lateener
marathoner1552883marathoner
marooned1138563marooned
mooner85317833__mooner
motioner1037593motioner
pardoner11189443pardoner
platooned1244393platooned
racoon83814473racoon__
racoons93912433racoon_s
ransomer1047883ransomer
rater54943283rat___er
rather94319743rat__her
rathole10312053rathole_
ratholes11312413ratholes
ratifier1139673ratifier
ratine65131823rat_ine_
ratines75328583rat_ines
ration64226013ration__
rational8412543rational
rations74123433ration_s
ratline74517803ratline_
ratlines83815293ratlines
ratooning1037173ratooning
rattened9218623rattened
ratteners9237263ratteners
ratter64326313rat__ter
rattier74015593rat_tier
rattler74012743rat_tler
ratton64116123ratton__
rattons73815323ratton_s
rattoon7359243rattoon__
rattoons8327513rattoon_s
ravener104110743ra_vener
rawboned14114253rawboned
reasoner849343reasoner
reckoner1446063reckoner
retainer82913813retainer
retooled938473retooled
retorter8410733retorter
returner8397983returner
roofer94415283r__oofer
roomer84718633r__oomer
rooser63921883r__ooser
rooter64926033r__ooter
rottener8216973rottener
schooner1336623schooner
sooner64220463__sooner
stationer946033stationer
stoner65823203_st_oner
stooker113811733_stooker
stooper93813193_stooper
swooner10358673_swooner
tattooer844373tattooer
toner55336243__t_oner
tonner64819203__tonner
tooler63818613__tooler
tooter64420803__tooter
uptowner1342043uptowner
waggoner1343423waggoner
wagoner1136093wa_goner
wantoner1187563wantoner

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.423422437.4
2DLD Change Limit146162937.95018385.2
3Display Results93930.0501860.0
 (SQL Overall)178691938.42321214.7
 
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.