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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

124 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
takin9492130(None) 
akin86328031_akin
tain45548071ta_in
taken94819141taken
taking114725951taking
takins105117401takins
agin56132712_agin
ain37579092_a_in
amin66042252_amin
ayin76331742_ayin
baking135626622baking
basin75026922basin
cabin94820942cabin
cain65643912ca_in
caking134624672caking
calkin123515492calkin
catkin123512382catkin
etamin81311852etamin
fagin9216572fagin
fain75840562fa_in
faking145520982faking
fakir125111492fakir
gain56042162ga_in
gamin84423002gamin
gaskin113610582gaskin
hakim14311832hakim
kain85334292ka_in
kaki76520912kaki_
kakis86116842kakis
kin76353972__kin
lain46146282la_in
laking115027042laking
lapin75222922lapin
layin84720332layin
main65345522ma_in
making134823852making
malkin122913152malkin
matin75132852matin
mavin105722952mavin
nankin1039672nankin
napkin1236902napkin
oaken95814382oaken
pain65647242pa_in
patin76832852patin
pavin105623202pavin
pekin111514422pekin
rain46251732ra_in
raki87127832raki_
raking114728422raking
rakis95323442rakis
ravin85624652ravin
rawin85521472rawin
sabin74924952sabin
sain45551292sa_in
saki85628482saki_
sakis95323672sakis
sarin55239252sarin
sasin54626572sasin
satin55935222satin
savin84625082savin
skin85927532_skin
stain55727942sta_in
staking123919802staking
statin63921472statin
tabid84418262tabid
tabun75914372tabun
tacit76333672tacit
tacking144421482tacking
tafia84215492tafia
tahini939892tahini
tail45443652ta_il
tains54936322ta_ins
taint55542282ta_int
taka87623592tak_a
takas95520682takas
take84739262tak_e
taker95229002taker
takes94437792takes
takings124512572takings
tali46837162tali_
talion6317712talion
talkie103914442talkie
talking123815822talking
talon55824112talon
tamein8313092tamein
taming94023432taming
tamis76728732tamis
tan37167572ta__n
tanking123918792tanking
tankini11338922tankini
tannin62613922tannin
taping94222392taping
tapir75917062tapir
tapis75028862tapis
taring73932282taring
tarn46842722ta_rn
tasking124616322tasking
tauon54816582tauon
tawie84819812tawie
tawing104521552tawing
taxi117124762taxi_
taxing143816712taxing
taxis126821972taxis
taxon124414662taxon
thein85919022thein
thin76732392t_hin
tiki87620842tiki_
tikis95615972tikis
tin36362172t__in
token95419312token
toking114420722toking
toxin124716712toxin
train56529112train
tsking114210422tsking
twain86313622twain
twin76023082t_win
tyin76424002t_yin
unakin10310962unakin
vain75233002va_in
vakil1259792vakil
wain75840202wa_in
waken124818472waken
waking144821382waking
zayin174512042zayin

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.313570897.8
2DLD Change Limit538001241.40338346.4
3Display Results1241240.0502480.0
 (SQL Overall)1786911241.766101184.0
 
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.