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

135 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
misdeem1221787(None) 
misdeed113211051misdeed
misdeems13255651misdeems
misdeal1037662misdeal
misdeeds12276812misdeeds
misdeemed1544602misdeemed
misdoer1048632misdoer
misdoes10312492misdoes
misdrew1335832misdrew
misfeed13389682misfeed
miskeep1536402miskeep
mismeet113215162mismeet
misterm114314512misterm
adeem8311803__adeem
beseem1069083bes_eem
deem75432893___deem
diadem1037583diad_em
dishelm1335833dishelm
esteem838813_esteem
idem76121073_i_d_em
indeed83913563_indeed
listee64223063listee_
listees73416673listees
meseems1165603mes_eems
mesoderm1344493mesoderm
mestee84523883mestee_
mestees94617753mestees
midden104112853mi_dden
middens11379383middens
middies113116153middies
middle103414983middle_
middled123311903middled
middler112712273middler
middles113415303middles
midge95016563mi_dge_
midges103516483mi_dges
midget103718453mi_dget
midleg1038553mi_dleg
midterm12316013midterm
midweek1743273midweek
milded104416153mild_ed
milden94113153mild_en
mildened1235773mildened
mildens10339933mildens
milder93818453mild_er
mildest102812063mildest
mildew12319043mild_ew
mildewed1543763mildewed
mildews13365883mildews
mildewy16353533mildewy
minded103817833mind_ed
minder94822503mind_er
minders103720123minders
mindset10313343mindset
misadded1335753misadded
misaim10311853mis_aim
misate81222693misate_
misaver1249813misaver
miscue10412223miscue_
miscued1239293miscued
miscues11312393miscues
misdate101413963misdate
misdated121211123misdated
misdates111113633misdates
misdealer1245593misdealer
misdeals1147233misdeals
misdealt1147983misdealt
misdeeming1644993misdeeming
misdial1039643misdial
misdid10510573misd_id
misdo85413193misd__o
misdoers1137103misdoers
misdone10310863misdone
misdraw1345623misdraw
mise66043593mis__e_
miseat82925713mis_eat
misedit10311043misedit
miser75430403mis__er
misers85025703mis_ers
misery114113543mis_ery
mises74740563mis__es
misesteem1344133misesteem
misfed124113023mis_fed
misfeeds14315623misfeeds
misform1437513misform
misgrew1335523misgrew
mishear1238393mishear
miskeeps1644163miskeeps
miskept1538923miskept
misknew1633883misknew
mislead10419973mislead
misled94719313mis_led
mislie83219153mislie_
mislies92922283mislies
mismeets12297733mismeets
mismet103722373mis_met
misname11119483misname
mispen10312173mis_pen
mispens11311073mispens
mispled12310463mispled
misread10339723misread
misrefer1346103misrefer
misrely12319613misrely
misseat93617243misseat
missed94423603mis_sed
missel85216523mis_sel
missels94614813missels
missend104411373missend
missent94318713missent
misses85130873mis_ses
misset85028153mis_set
missets94516573missets
missies93423983missies
missteer1037223missteer
misstep11158463misstep
misted93625823mis_ted
mistend103812523mistend
mister84728563mis_ter
misterms123711353misterms
misters93927513misters
misteuk1335893misteuk
mistier93418713mistier
mistime11312613mistime
misuse83213643misuse_
misused104111283misused
misuser93210443misuser
misuses93216023misuses
modem103717143m_od_em
museum1037703mus_eum
mustee83922103mustee_
mustees94614923mustees
redeem9311533_redeem
seem65438563__s_eem
viseed105310983vis_eed
wisdom1235983wisd_om

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 Limit1340271355.86022871.5
3Display Results1351350.0602250.0
 (SQL Overall)1786911356.32628247.1
 
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.