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

101 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
attorned95535(None) 
attorney1173721attorney
acorned10238272a_corned
adorned9256892a_dorned
atoned75417542a_to_ned
attained997352attained
attired8238912attir_ed
attorn6310792attorn__
attorneys1252032attorneys
attorns738442attorn_s
attuned835172att_uned
patterned1265742patterned
rattooned1043842rattooned
thorned11479402_thorned
abhorred1443493abhorred
aborted10310423a_borted
absorbed1344263absorbed
accorded14155353accorded
adjoined1743513adjoined
adjourned1842063adjourned
adored84714243a_dor_ed
adorner8246983a_dorner
adsorbed1243443adsorbed
afforded1643433afforded
altered83215733alter_ed
antired82316193antir_ed
aproned10311503apro_ned
arbored103811603arbor_ed
armored102610473armor_ed
assorted956603assorted
astonied978983astonied
astound845503astoun_d
astounded1143223astounded
atone56527983a_to_ne_
atoner64817193a_to_ner
atones65225773a_to_nes
attached14165703attached
attacked15125113attacked
attainer8116913attainer
attainted1044693attainted
attend7258973att_en_d
attended1035763attended
attested936293attested
attire62412383attir_e_
attires72312953attir_es
attorning1045503attorning
attornment1274583attornment
attrited947373attrited
attune637983att_une_
attunes737823att_unes
authored1238263author_ed
autoed7712823auto__ed
battened11259573batt_ened
battered113315053batter_ed
bethorned1544443bethorned
buttoned1137503butto_ned
cantoned111411523canto_ned
cartoned111312833carto_ned
cartooned1246313cartooned
corned95224523__corned
cottoned1138033cotto_ned
dehorned1345683dehorned
extorted1636233extorted
factored1436213factor_ed
fattened12268283fatt_ened
horned105718703__horned
interned93016653interned
intoned8811993into_ned
intorted9310123intorted
inturned9268313inturned
mattered112412903matter_ed
motored1039933motor_ed
nattered92011623natter_ed
pastored1139963pastor_ed
pattened11299393patt_ened
pattered112714203patter_ed
rationed9410093ratio_ned
ratooned977103ratooned
rattened9218623ratt_ened
retorted9312333retorted
returned9459133returned
scorned10229953_scorned
sorned74820043__sorned
stoned75923143_sto_ned
stored75524213_stor_ed
storied8515163_storied
stormed1039043_stormed
suborned1137303suborned
tabored102810563tabor_ed
taloned8310223talo_ned
tattered92011443tatter_ed
tattooed944573tatto_oed
throned115412173_throned
toned65435343__to_ned
turned73914473__turned
tutored837553tutor_ed
unturned9228563unturned
upturned11214013upturned
uttered82712433utter_ed
wantoned12117223wanto_ned
yattered12239533yatter_ed

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.420425454.8
2DLD Change Limit1461621017.64019131.2
3Display Results1011010.0502020.0
 (SQL Overall)1786911018.11022033.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.