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

111 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
miskick143561(None) 
miskicks1544761miskicks
miskicked1744062miskicked
musick14408702mus_ick
airsick1395333airsick
bigstick1744283bigstick
dipstick1775223dipstick
disking134615493disking
distich13312173distich
fistic11812573fistic_
fossick16134733fossick
gimmick1843273gimmick
kick96026073___kick
killick1295313killick
lipstick1684493lipstick
maffick2143523maffick
masking145116613masking
mastic103119173mastic_
mastics112614783mastics
medick154010133m_edick
mesic93617863mes_ic_
miasmic1335743miasmic_
mick126333433m___ick
miking134218463mi_king
milkier133411163milkier
milkily16216553milkily
milking143712763milking
mimic111414323mi_mic_
mimics1289363mi_mics
miotic103715753miotic_
miotics112710653miotics
mirkier13319053mirkier
mirkily16266403mirkily
misact10316693mis_act
misaim10311853misai_m
misaims11310113misaims
misbias1139083misbias
misbill1137033misbill
misbind1258273misbind
miscite11314383miscite
miscook1546473miscook
misdial1039643misdial
misdid10510573misdi_d
misfile122611553misfile
misfire12229893misfire
misfit112813833misfi_t
misfits12279663misfits
misgive13339033misgive
mishit112618203mishi_t
mishits122513083mishits
miskal123710263misk_al
miskals13369763miskals
miskeep1536403miskeep
miskept1538923miskept
miskicking1844243miskicking
misknew1633883misknew
misknow1643213misknow
mislie83219153misli_e
mislies92922283mislies
mislike132914833mislike
mislit83019693misli_t
mislive122812693mislive
mismark1536703mismark
mispickel1942973mispickel
misprice1448133misprice
missies93423983missies
missile92815403missile
missing103619073missing
mission9312743mission
missis84417503missi_s
missive122413143missive
misteuk1335893misteuk
misthink1745433misthink
mistier93418713mistier
mistily122612343mistily
mistime11312613mistime
misting103623383misting
mistook1337153mistook
mosaic10311143mosaic_
mosaics1138073mosaics
music94316403mus_ic_
musicks15297053mus_icks
musics103911783mus_ics
muskie123412543muski_e
muskier134312733muskier
muskies133614673muskies
muskily16289043muskily
muskit122813253muski_t
muskits13278563muskits
mystic132711643mystic_
mystics14279103mystics
niblick1544453niblick
nitpick1543783nitpick
outkick1235573outkick
pickwick2042293pickwick
pigstick1744933pigstick
riskier1138423riskier
riskily1436413riskily
risking123914243risking
sick106435573__s_ick
sidekick1442633sidekick
siskin1079783siski_n
siskins1159583siskins
skink85916853__skink
slick115520523__slick
snick114416013__snick
spick134519073__spick
stick115121563__stick
topkick1443143topkick
unslick1356023unslick
unstick1338123unstick

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 Limit1340271116.43620824.6
3Display Results1111110.0462413.0
 (SQL Overall)1786911116.88825942.4
 
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.