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

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

73 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
miskicks154476(None) 
miskick1435611miskick_
miskicked1744062miskicked
musicks15297052mus_icks
dipsticks1864213dipsticks
distichs1447633distichs
fossicks17134163fossicks
gimmicks1942473gimmicks
kicks104420083___kicks
killicks1354873killicks
lipsticks1773773lipsticks
mafficks2243173mafficks
maskings15448753maskings
mastics112614783mastic_s
medicks16368413m_edicks
micks135525373m___icks
mimics1289363mi_mic_s
miotics112710653miotic_s
misacts1139353mis_acts
misaims11310113misai_ms
misbias1139083misbi_as
misbills1246083misbills
misbinds1345163misbinds
miscites12313783miscites
miscooks1645463miscooks
misdials1137503misdials
misfiles133110983misfiles
misfires132210583misfires
misfits12279663misfi_ts
misfocus1543453misfocus
misgives14329293misgives
mishits122513083mishi_ts
miskals13369773misk_als
miskeeps1644163miskeeps
miskicking1844243miskicking
misknows1743063misknows
mislies92922283misli_es
mislike132914833misli_ke
mislikes143311833mislikes
mislives132912153mislives
mismarks1645893mismarks
mispickel1942973mispickel
mispickels2041753mispickels
misprices1547913misprices
missies93423983missi_es
missiles103015083missiles
missions10311903missions
missis84417503missi__s
missises103513693missises
missives133212843missives
misthinks1843353misthinks
mistimes12612613mistimes
mosaics1138073mosaic_s
musick14408703mus_ick_
musics103911783mus_ic_s
muskies133614673muski_es
muskits13278563muski_ts
mystics14279103mystic_s
niblicks1643763niblicks
nitpicks1643183nitpicks
outkicks1344603outkicks
pickwicks2142223pickwicks
pigsticks1843963pigsticks
sicks115127623__s_icks
sidekicks1542393sidekicks
siskins1159583siski_ns
skinks94511653__skinks
slicks124816113__slicks
snicks124312473__snicks
spicks144814993__spicks
sticks125118613__sticks
topkicks1542633topkicks
unsticks1436233unsticks

Search took 9 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 Filter1786911461620.450397091.1
2DLD Change Limit146162737.58019282.6
3Display Results73730.0302433.3
 (SQL Overall)178691738.06022170.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.