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

141 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
miskeep153640(None) 
miskeeps1644161miskeeps
misdeed113211052misdeed
misdeem12217872misdeem
misfeed13389682misfeed
miskept1538922miskept
misknew1633882misknew
mismeet113215162mismeet
misstep11158462misstep
asleep847283_asleep
barkeep1536363barkeep
disked125015763disk_ed
keep106329833___keep
listee64223063listee_
listees73416673listees
makeup1434863m_akeup
masked134316523mask_ed
maskeg13388693mask_eg
maskegs14375413maskegs
masker124416103mask_er
maskers133913843maskers
mestee84523883mestee_
mestees94617753mestees
mickey174211853mick_ey
mickeys18447943mickeys
mickle143715133mickle_
mickler153310233mickler
mickles153415003mickles
midweek1743273midweek
mike105535303mi_k_e_
miked125020453mi_k_ed
mikes115129893mi_k_es
mikveh18132543mi_kveh
milked134612573milk_ed
milker124814323milk_er
milkers134411613milkers
milkier133411163milkier
milkmen1565213milkmen
milksop1542833milksop
milkweed1843353milkweed
minke115421763mink_e_
minkes124618783mink_es
mirker123712693mirk_er
mirkest13309723mirkest
mirkier13319053mirkier
misate81222693misate_
misaver1249813misaver
miscue10412223miscue_
miscued1239293miscued
miscues11312393miscues
misdeal1037663misdeal
misdeeds12276813misdeeds
misdeems13255653misdeems
misdoer1048633misdoer
misdoes10312493misdoes
misdrew1335833misdrew
mise66043593mis__e_
miseat82925713mis_eat
miser75430403mis__er
misers85025703mis_ers
misery114113543mis_ery
mises74740563mis__es
misfed124113023mis_fed
misfeeds14315623misfeeds
misgrew1335523misgrew
mishap1338873mis_hap
mishear1238393mishear
miskal123710263misk_al
miskals13369773miskals
miskeeping1944353miskeeping
miskick1435613miskick
misknow1643213misknow
mislead10419973mislead
misled94719313mis_led
mislie83219153mislie_
mislies92922283mislies
mismeets12297733mismeets
mismet103722373mis_met
mispen10312173mis_pen
mispens11311073mispens
mispled12310463mispled
misread10339723misread
misrefer1346103misrefer
misrely12319613misrely
misseat93617243misseat
missed94423603mis_sed
missel85216523mis_sel
missels94614813missels
missend104411373missend
missent94318713missent
misses85130873mis_ses
misset85028153mis_set
missets94516573missets
missies93423983missies
missteer1037223missteer
missteps12156143missteps
misstop11156413misstop
misted93625823mis_ted
mistend103812523mistend
mister84728563mis_ter
misterm114314513misterm
misters93927513misters
misteuk1335893misteuk
mistier93418713mistier
mistype14126523mistype
misuse83213643misuse_
misused104111283misused
misuser93210443misuser
misuses93216023misuses
muskeg13338183musk_eg
muskegs14285013muskegs
musket122818203musk_et
muskets13258643muskets
muskie123412543muskie_
muskier134312733muskier
muskies133614673muskies
mustee83922103mustee_
mustees94614923mustees
outkeep1345673outkeep
pickeer153710113pickeer
risked115514633risk_ed
risker105414493risk_er
riskers114011993riskers
riskier1138423riskier
seep66540343__s_eep
sheep105321523__sheep
sickee124622223sickee_
sickees134514213sickees
skee85431473__skee_
skeed105018983__skeed
skeen94817403__skeen
skees95023123__skees
skeet95429183__skeet
skelp114211423__skelp
skep105219353__sk_ep
sleep74920183__sleep
steep76020703__steep
sweep104715723__sweep
upkeep1434143_upkeep
upsweep1442573upsweep
viseed105310983vis_eed

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.390458182.1
2DLD Change Limit1340271416.73619897.1
3Display Results1411410.0602350.0
 (SQL Overall)1786911417.18624866.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.