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

176 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
tanuki103491(None) 
tanukis1134711tanukis
azuki1864802_azuki
kabuki1143962kabuki
saluki1036202saluki
tabuli839362tabuli
taluk94812872taluk_
taluka10426772taluka
taluks10418282taluks
tank85134022tan_k_
tanka93817482tan_ka
tanks94624732tan_ks
tenuti638972tenuti
adzuki2042523adzuki
ani37751183_an__i
animi74016663_animi
ankh111114413_an_kh
ankus91410683_ankus
annuli6459053annuli
anti45536363_an_ti
anuria6313123_anuria
anuric8812103_anuric
anus47131113_anu_s
auk76234143_a_uk_
auks85525263_a_uks
azukis1963733_azukis
bani65334963ban__i
bank105835753ban_k_
bankit123617043ban_kit
banks115527903ban_ks
banzai1737653banzai
buzuki2142763buzuki
canakin131810833canakin
canikin13189753canikin
canthi11310973canthi
canula8312963canula
dank95828243dan_k_
ennui537523ennu_i
enoki9268873_enoki
famuli1136763famuli
fanum10313443fanu_m
fanums1137263fanums
hamuli1137063hamuli
hank115134143han_k_
hankie133915713han_kie
hanks126226863han_ks
hanky155418293han_ky
jauk155816093ja_uk_
jauks165412463ja_uks
kabiki1134783kabiki
kabukis1243193kabukis
kaki76520913ka__ki
kanaka9357523kanaka
kanji1647453kan_ji
kauri93811853ka_uri
lanai5319573lan_ai
lank84734453lan_k_
lanky125517483lan_ky
lanugo735573lanugo
lazuli1535363lazuli
manakin131810643manakin
manikin132110243manikin
manual8313463manual
manumit1149573manumit
manure8313653manure
manus75924933manu_s
maqui16249953maqu_i
nankin1039673nan_kin
nuke85920753__nuke
panini8314273panini
raki87127833ra__ki
rani46640113ran__i
rank85135533ran_k_
ranks95225733ran_ks
ranula6311813ranula
saki85628483sa__ki
salukis1136033salukis
sandhi1038193sandhi
sank85236833san_k_
sansei63411903sansei
stank95823303stan_k_
stanks104917703stan_ks
tabouli945843tabouli
tabu66328493tabu__
tabued94310403tabued
tabulis938833tabulis
tabun75914373tabu_n
tabuns8489223tabuns
tabus74820923tabu_s
tack106536293ta_ck_
tacks115430133ta_cks
tacky145617443ta_cky
tahini939893tahini
taka87623593ta__ka
take84739263ta__ke
takin94921303ta__kin
talcky15294723talcky
tali46837163ta__li
talk86230093ta_lk_
talkie103914443ta_lkie
talks94322693ta_lks
talky126215683ta_lky
talukas11316213talukas
talus55423263talu_s
tamari8313403tamari
tan37167573tan___
tandem9311403tandem
tang56138673tan__g
tanga64923693tan_ga
tanged84622493tanged
tangle74019953tangle
tangly104413913tangly
tango66921173tan_go
tangos74216303tangos
tangs65028343tan_gs
tangy94519933tan_gy
tanist6324593tanist
tankas104613763tankas
tanked113919293tanked
tanker104521123tanker
tanking123918793tan_king
tankini11338923tankini
tanned75219953tanned
tanner63722283tanner
tannic82811473tannic
tannin62613923tannin
tannoy958353tannoy
tanrec837803tanrec
tans46154823tan__s
tansy84514933tan_sy
tanto55724943tan_to
tantra63713353tantra
tantric939583tantric
tarok97921073tarok_
taroks106115283taroks
tarsi55222173ta_rsi
task85326653ta_sk_
tasks94917583ta_sks
tatami839193tatami
tatsoi637263tatsoi
tau36856903ta_u__
taunt55532283ta_unt
taunts65715663taunts
tauon54816583ta_uon
taupe7314163ta_upe
taus46342733ta_u_s
taut47048963ta_u_t
tauts56125513ta_uts
taxi117124763ta__xi
taxus125512483taxu_s
tenues63816443tenues
tenuis64213083tenuis
tenure6311613tenure
tenuto648743tenuto
thank125817803than_k_
thanks134313133than_ks
thunk124911853thunk_
thunks13459033thunks
tiki87620843t__iki
tondi65716143ton_di
tonus56324303tonu_s
trank96222423tran_k_
tranks104017763tran_ks
trunk94713043trunk_
trunks10429753trunks
tui37034023t__u_i
tumuli835933tumuli
twanky16445773twan_ky
wakiki1233463wakiki
wank115632513wan_k_
wanks126124483wan_ks
wauk115220593wa_uk_
wauks125515163wa_uks
yank115423673yan_k_
yanks125316573yan_ks
yanqui1843383yanqui

Search took 6 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 Filter1786911127160.1261418182.5
2DLD Change Limit1127161765.14021929.2
3Display Results1761760.0463826.1
 (SQL Overall)1786911765.31233639.1
 
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.