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

151 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
kismats1325784(None) 
kismat123011671kismat_
kismets13306881kismets
dismals102010242dismals
dismast10311232dismast
dismasts1137512dismasts
dismays13237432dismays
kismet123414622kismet_
kists95822112kis__ts
miseats92815782miseats
mismate111415352mismate
mismates121114562mismates
basmati1148233basmati
basmatis1247343basmatis
besmuts1134683besmuts
bimahs13508303bi_mahs
bimas95521743bi_ma_s
biomass1155993biomass
bisects1137133bisects
bismuth1443723bismuth
bismuths1542533bismuths
bistate9313823bistate
bitmaps1344253bitmaps
cists76624533cis__ts
cushats12288273cushats
desmans1039003desmans
diktats1235623diktats
diquats1745983diquats
disbars10310323disbars
discants112912023discants
dismal92412243disma_l
dismay12229473disma_y
dismes95617673dism_es
dismiss1038153dismiss
disparts11109953disparts
disrate81418523disrate
disrates91118153disrates
disseats93211503disseats
fiats85324483fi__ats
firmans12238523firmans
fiscals1238003fiscals
fissate103010033fissate
fists85527543fis__ts
formats123113573formats
gimmals12225823gimmals
gismos957183gism_os
gists66026193gis__ts
hazmats2136603hazmats
hists86328373his__ts
ikats95311153_i_kats
imams91511113_i_mams
inmate82917363_inmate
inmates92715783_inmates
isbas71010403_isba_s
islets64513083_islets
isms66213473_ism__s
jisms14458003jism__s
karats106420493k_arats
karmas123013733karma_s
kasbahs1634363kasbahs
kashas133311903kasha_s
kats85944333k___ats
khats125316013k__hats
kiblahs1634153kiblahs
kiblas1239323kibla_s
kidnaps1453323kidnaps
kilts95122183ki__lts
kinas95626913ki_na_s
kinemas1336893kinema_s
kinsman1335963kinsma_n
kirmess13234313kirmess
kishkas1343483kishkas
kishkes1334773kishkes
kismetic1644883kismetic
kiss85227393kis___s
kissers114211293kissers
kisses104217333kis_ses
kist86540793kis__t_
kitbags1443883kitbags
kits86441763ki___ts
kivas124614733ki_va_s
korats105416063k_orats
kormas124511233korma_s
kyats125012443k__yats
limans84816303li_mans
limas75627633li_ma_s
limits82514143li_mits
lists56628693lis__ts
mats65460293___mats
miasmas1167743miasma_s
miasmata1244503miasmata
misacts1139353misacts
misate81222693mis_ate
miscast11312413miscast
miscasts1238343miscasts
miscuts1139183miscuts
misdate101413963misdate
misdates111113633misdates
miseat82925703miseat_
misfits12279663misfits
mishaps1438713mishaps
mishits122513083mishits
miskals13369763miskals
mislays12349243mislays
mismade12129353mismade
mismake15139373mismake
mismakes16129883mismakes
mismark1536703mismark
mismarks1645893mismarks
mismatch1743943mismatch
mismated131111333mismated
mismeets12297733mismeets
mismet103722373mismet_
misparts12108173misparts
misrate91319143misrate
misrates101318243misrates
missals93914423missals
missays124010253missays
misseats104011683misseats
missets94516573missets
mists76633903mis__ts
muscats1138933muscats
pimas94725103pi_ma_s
pissants1097363pissants
pitmans11188743pitmans
reseats74319583reseats
scats75930603__scats
seats54844343__seats
sigmas94111363sigma_s
sigmate10710143sigmate
simars84916933si_mars
simas75727553si_ma_s
sisals63013573sis_als
skats94621543__skats
slats55436903__slats
smalts85214893__smalts
smarts86218003__smarts
smuts75415713__smuts
spats75031383__spats
stats55933363__stats
swats85726863__swats
tipcats1137103tipcats
unseats73012853unseats
visas84317653vis_a_s
visits9311423vis_its
vistas94513273vista_s
visuals1036853visuals
wiseass1035823wiseass
wisents10249063wisents
wists86728523wis__ts
yasmaks1633653yasmaks

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 Limit1340271515.87322820.9
3Display Results1511510.0632396.8
 (SQL Overall)1786911516.34228175.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.