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

107 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
nankeen113504(None) 
nankeens1243241nankeens
canteen9411082canteen
nankin1039672nank_in
ackee115825373_ackee_
ackees124914583_ackees
akee85936813_a_kee_
akees96119243_a_kees
akene95818663_a_kene
alkene104114003_alkene
ananke1038283anank_e_
anankes1138763anank_es
ankle95220253_ankle_
ankled114313483_ankled
ankles104818383_ankles
anklet105618733_anklet
anteed75616113_anteed
atween9166613_atween
baleen8613053ba_leen
banked135021443bank_ed
banker124222733bank_er
bankers133919093bankers
barkeep1536363barkeep
buckeen1536703buckeen
canker124422523cank_er
cankered153010223cankered
cankers134418753cankers
canteens1038573canteens
careen84119493ca_reen
danker114319663dank_er
dankest122611673dankest
darken114013443dark_en
dasheen1136393dasheen
fakeer13378743fa_keer
flanken14226763flank_en
hackee154921833hackee_
hackees165014103hackees
hackmen1836713hackmen
hakeem15407383ha_keem
hangmen1337383hangmen
hanked144220603hank_ed
hanker134622093hank_er
hankered16289443hankered
hankerer15248233hankerer
hankers144218133hankers
hankie133915713hankie_
hankies143617763hankies
harken135116343hark_en
junkmen2033633junkmen
kamseen1344013kamseen
keen84830413___keen
landmen1038553landmen
lanker104123003lank_er
lankest112714113lankest
lankier113711633lankier
lantern7310013lantern
lateen64014863la_teen
linkmen1335363linkmen
naked105320853na_k_ed
nakeder1254363na_keder
nance74721843nan_ce_
nances83618643nan_ces
nancies93516843nancies
nandin7313033nan_din
nankins1159053nankins
nannie63713223nannie_
nannies73015203nannies
napkin1236903napk_in
narcein936293narcein
narked114116743nark_ed
nineteen844153nineteen
nongreen945513nongreen
nonmen8412833non_men
oaken95814383oa_k_en
packmen1746313packmen
palankeen1542503palankeen
pangen94115913pan_gen
pangene102711963pangene
pinken124513283pink_en
rakee96031173ra_kee_
rakees104516973ra_kees
ranee55438103ran_ee_
ranees64623963ran_ees
ranked114620743rank_ed
ranker105021903rank_er
rankers113217463rankers
rankest112713813rankest
rankle103414883rankle_
rankled123910653rankled
rankles113114543rankles
ratteen7329113ratteen
sandmen1039413sandmen
sateen63815013sa_teen
skeen94817403__skeen
sunken103511783sunk_en
taken94819143ta_k_en
tanked113919293tank_ed
tanker104521123tank_er
tankers113416913tankers
unseen62012623_unseen
vakeel1335193va_keel
vanmen1138403van_men
waken124818473wa_k_en
wanked144517153wank_ed
wanker134219973wank_er
wankers144514713wankers
yanked144312243yank_ed

Search took 7 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 Filter1786911340270.406440125.6
2DLD Change Limit1340271075.98322401.3
3Display Results1071070.0303566.7
 (SQL Overall)1786911076.41927837.8
 
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.