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

161 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
miskept153892(None) 
discept12310622discept
mirkest13309722mirkest
miseat82925712mis_eat
miskeep1536402miskeep
miskeeps1644162miskeeps
mismeet113215162mismeet
mismet103722372misme_t
misseat93617242misseat
missent94318712missent
misset85028152misse_t
musket122818202muske_t
basket125722913baske_t
bisect10312873bis_ect
bosket124919223boske_t
briskest14337803briskest
brisket134413403briske_t
casket124820993caske_t
discepts1336743discepts
disject17268673disject
disked125015763diske_d
diskette1346753diskette
disrupt1048633disrupt
disseat83816923disseat
dissect103614133dissect
dissent84018683dissent
dissert83720693dissert
distent84120853distent
frisket143811773friske_t
gasket114417253gaske_t
incept102712753_incept
inept73622153_i_nept
inswept1245733inswept
islet54527553_isle_t
kept106232943___kept
kismet123414623kisme_t
likest104914383li_kest
market123226043marke_t
masked134316523maske_d
maskeg13388693maske_g
maskegs14375413maskegs
masker124416103maske_r
maskers133913843maskers
meekest1336893meekest
mickey174211853micke_y
mickeys18447943mickeys
micklest16219123micklest
midget103718453midge_t
mike105535293mi_ke__
miked125020453mi_ke_d
mikes115129893mi_ke_s
mikvot1556763mi_kvot
mildest102812063mildest
milked134612573milke_d
milker124814323milke_r
milkers134411613milkers
milkiest142911083milkiest
millet84030743mille_t
minke115421763minke__
minkes124618783minke_s
minuet82621033minue_t
miriest93619823miriest
mirker123712693mirke_r
mirkiest142910253mirkiest
misact10316693mis_act
misadapt1345203misadapt
misagent11410723misagent
misbegot1344773misbegot
miscast11312423miscast
miscopy1636663miscopy
miscut10614823mis_cut
misdeal1037663misdeal
misdealt1147983misdealt
misdeed113211053misdeed
misdeem12217873misdeem
mise66043583mis_e__
miseats92815783mis_eats
misedit10311043misedit
miser75430403mis_e_r
misers85025703mis_ers
misery114113543mis_ery
mises74740563mis_e_s
misevent1349223misevent
misfed124113023misfe_d
misfeed13389683misfeed
misfit112813833mis_fit
mishap1338873mishap_
mishaps1438723mishaps
mishear1238393mishear
mishit112618203mis_hit
miskal123710263misk_al
miskals13369763miskals
miskick1435613miskick
misknew1633883misknew
misknow1643213misknow
mislead10419973mislead
misled94719313misle_d
mislit83019693mis_lit
mismeets12297733mismeets
mispart111113783mispart
mispen10312173mispe_n
mispens11311073mispens
misread10339723misread
misrely12319613misrely
misreport1346053misreport
misseats104011683misseats
missed94423603misse_d
missel85216523misse_l
missels94614813missels
missend104411373missend
misses85130873misse_s
missets94516573missets
missort9314653missort
missout9412663missout
misspelt1247273misspelt
misspent1259173misspent
misstep11158463misstep_
missteps12156143missteps
missuit9911303missuit
mist66154533mis___t
misted93625823miste_d
mistend103812523mistend
mister84728563miste_r
misterm114314513misterm
misters93927513misters
misteuk1335893misteuk
mistiest103018313mistiest
mistreat10313113mistreat
mistype14126523mistype
miswrit1249413miswrit
mitiest93520053mitiest
moistest1038763moistest
mostest9314793mostest
murkest133110203murkest
muskeg13338183muske_g
muskegs14285013muskegs
muskets13258643muskets
muskiest143311563muskiest
muskit122813253musk_it
muskrat1346733muskrat
outkept1337883outkept
picket144924313picke_t
pinkest132812623pinkest
risked115514633riske_d
risker105414493riske_r
riskers114011993riskers
riskiest12310133riskiest
sept65844363__s_ept
sickest131813793sickest
skeet95429183__skeet
skep105219353__skep_
skeps115614253__skeps
slept75728103__slept
swept105720603__swept
ticket124524853ticke_t
unkept123710873_unkept
unswept1246013unswept
upswept1443473upswept
wicket155318943wicke_t
wisent93516343wis_ent
wisest95016443wis_est

Search took 8 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.813219792.1
2DLD Change Limit1340271617.09318895.7
3Display Results1611610.0463500.0
 (SQL Overall)1786911617.95222471.2
 
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.