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

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

98 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
tanka9381749(None) 
taka87623591ta_ka
tanga64923711tanga
tank85134031tank_
tankas104613771tankas
tanks94624741tanks
ana39559832_an_a
anga56831362_anga
ankh111114412_ankh
anna45529012_anna
anoa45634472_anoa
ansa45927772_ansa
anta46839582_anta
babka137812912babka
banda85223112banda
bank105835752bank_
banks115527902banks
canna75919332canna
dank95828242dank_
fanga96119632fanga
ganja131410002ganja
haika125313792haika
hank115134142hank_
hanks126226862hanks
hanky155418292hanky
hansa85416782hansa
kaka76518682ka_ka
kana85928532kan_a
kanaka9357522kanaka
lank84734452lank_
lanky125517482lanky
mana65341962man_a
manga85026212manga
mania75634152mania
manna75522542manna
manta75629912manta
marka114620792marka
nana46632902nan_a
panda85022612panda
panga85323542panga
parka115120882parka
punka114515482punka
rank85135532rank_
ranks95225732ranks
sanga66023802sanga
sank85236832sank_
stank95823302stank_
stanks104917702stanks
stanza1537072stanza
tabla73318362tabla
tack106536292tack_
tacks115430132tacks
tacky145617442tacky
taenia6313192taenia
tafia84215492tafia
taiga64115672taiga
takas95520682ta_kas
take84739262ta_ke
tala45938052ta_la
talk86230092talk_
talks94322692talks
talky126215682talky
taluka10426772taluka
tan37167582tan__
tang56138692tan_g
tango66921192tango
tangs65028362tangs
tangy94519952tangy
tankage12257772tankage
tankard1267262tankard
tanked113919302tanked
tanker104521132tanker
tans46154832tan_s
tansy84514942tansy
tanto55724952tanto
tantra63713362tantra
tanuki1034922tanuki
tapa65129152ta_pa
task85326652task_
tasks94917582tasks
taxa116820092ta_xa
tazza1338082tazza
tenia55324482tenia
thank125817802thank_
thanks134313132thanks
tikka835572tikka
tinea54923162tinea
tonga65619702tonga
trank96222422trank_
tranks104017762tranks
tuna45127842tun_a
twanky16445772twanky
vanda94515922vanda
wank115632512wank_
wanks126124482wanks
yank115423672yank_
yanks125316572yanks
zanza1378702zanza

Search took 2 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 Filter178691538000.310576422.6
2DLD Change Limit53800981.47036598.6
3Display Results98980.0303266.7
 (SQL Overall)178691981.81098724.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.