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

133 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
ratooned97710(None) 
rationed9410091rationed
ratooner887001ratooner
rattooned1043841rattooned
atoned75417542_at_oned
cartooned1246312cartooned
dragooned1242962dragooned
marooned1138562marooned
platooned1244402platooned
ratoon64417372ratoon__
ratooners965832ratooners
ratoons73815472ratoon_s
rattened9218622rattened
rawboned14114252rawboned
retooled938472retooled
acorned10238283_acorned
adorned9256893_adorned
aproned10311503_aproned
atone56527983_at_one_
atoner64817193_at_oner
atones65225773_at_ones
attorned955363attorned
attuned835173_attuned
ballooned1245103ballooned
bastioned1246863bastioned
battened11259573battened
buttoned1137503buttoned
cannoned11118143cannoned
cantoned111411523cantoned
captioned1445763captioned
cartoned111312833cartoned
cautioned1245363cautioned
cocooned1337293cocooned
cottoned1138033cottoned
crayoned1435003cra_yoned
crooned103813353_crooned
fathomed1744733fathomed
fattened12268283fattened
festooned1344303festooned
fractioned1644613fractioned
gadrooned1243403gadrooned
gallooned1144473gallooned
gammoned1444993gammoned
hamboned1637003hamboned
harpooned1544323harpooned
intoned8811993int_oned
jargoned1735233jargoned
jawboned21133553jawboned
lampooned1443573lampooned
latened8711923lat_ened
masoned1039803ma_soned
mooned94216643__mooned
motioned1137453motioned
optioned1146383optioned
pardoned12189333pardoned
patined105114783pat_ined
pattened11299393pattened
racoon83814473racoon__
racoons93912433racoon_s
radioed939673radio_ed
ragouted1034423ragouted
rained75024603ra__ined
rancored1137233rancored
ransomed1146933ransomed
rated65441383rat___ed
rathole10312053rathole_
ratholes11312413ratholes
ratified12310503ratified
ratine65131823rat_ine_
ratines75328583rat_ines
ration64226013ration__
rational8412543rational
rations74123433ration_s
ratline74517803ratline_
ratlines83815293ratlines
ratooning1037173ratooning
ratted74923343rat__ted
rattener8238533rattener
rattled84012953rat_tled
ratton64116123ratton__
rattons73815323ratton_s
rattoon7359243rattoon__
rattoons8327513rattoon_s
ravened115012283ra_vened
ravined115411823ra_vined
razored1736333ra_zored
readorned1145183readorned
reasoned9410733reasoned
rebooked15226503rebooked
rebooted11248463rebooted
reckoned1546963reckoned
recoined113614433recoined
reconned113610663reconned
recooked15268253recooked
redonned10297103redonned
rejoined16318593rejoined
reloaned939723reloaned
relooked13236653relooked
renowned1235983renowned
reroofed1235883reroofed
retained93016093retained
retorted9312333retorted
retuned86613973ret_uned
returned9459133returned
rezoned173611163r_ezoned
ribboned1343973ribboned
roofed105214743r__oofed
rooked114918143r__ooked
roomed95218543r__oomed
roosed75621603r__oosed
rooted75424003r__ooted
spooned103412443_spooned
stationed1046143stationed
stoned75923143_st_oned
stooged94310733_stooged
stooked124312303_stooked
stooled84313893_stooled
stooped103813833_stooped
swooned11368593_swooned
tabooed10267383taboo_ed
taloned8310223ta_loned
tamponed1336023tamponed
tattooed944573tattooed
toned65435343__t_oned
tooled74918903__tooled
tooted74620123__tooted
unatoned939423unat_oned
vamoosed1443923vamoosed
varoomed1445293varoomed
waggoned1443253waggoned
wagoned1256223wa_goned
wantoned12117223wantoned
zooned164011083__zooned

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.440406115.9
2DLD Change Limit1461621337.46619577.0
3Display Results1331330.0632111.1
 (SQL Overall)1786911337.96922423.3
 
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.