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

114 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
misdeals114722(None) 
misdeal1037661misdeal_
misdealt1147981misdealt
misdials1137491misdials
ideals75012502_i_deals
misdealer1245592misdealer
misdealers1344612misdealers
misdeeds12276812misdeeds
misdeems13255652misdeems
misdial1039642misdial_
misdraws1445752misdraws
miseats92815782mis_eats
mishears1338322mishears
miskals13369762mis_kals
misleads11358542misleads
misreads11268922misreads
missals93914422mis_sals
misseats104011682misseats
missels94614812misse_ls
mistrals101212622mistrals
deals65435343___deals
dismals102010243dis_mals
dispels10310503dispe_ls
disseats93211503disseats
fiscals1238003fis_cals
fishmeals1742033fishmeals
ideal65716393_i_deal_
ideas65919013_i_dea_s
listels74212433liste_ls
meals75933373m___eals
medals94218053m_ed_als
medials103914733m_edials
megadeals1342713megadeals
mescals112911563mes_cals
micells11107683mi_cells
middays14335663mi_ddays
middens11379383midde_ns
midways16386183mi_dways
midyears1443403midyears
mildens10339933milde_ns
mildews13365883milde_ws
minders103720123minde_rs
minerals10311373minerals
minimals12327433minimals
misbias1139083misbia_s
misbills1246083misbills
miscall1139653mis_call
miscalls1239003miscalls
misclass1246843misclass
misdate101413963misd_ate
misdates111113633misdates
misdealing1457363misdealing
misdeed113211053misde_ed
misdeem12217873misde_em
misdialed1345513misdialed
misdoers1137103misdoers
misdoes10312493misd_oes
misdraw1345623misdra_w
misdrawn1444343misdrawn
misease92713043mis_ease
miseases102614343mis_eases
miseat82925713mis_ea_t
misedits1147963misedits
miserly12329823mis_erly
misers85025703mis_e_rs
mises74740563mis_e__s
misfeeds14315623misfeeds
mishaps1438723mis_haps
mishear1238393mishea_r
misheard1446253misheard
mishegaas1562193mishegaas
miskal123710263mis_kal_
miskeeps1644163miskeeps
mislays12349243mis_lays
mislead10419973mislea_d
mislearn1045343mislearn
mislearns1144523mislearns
mismeets12297733mismeets
mispens11311073mispe_ns
misplans1238863misplans
misplays1555543misplays
mispleads1444203mispleads
misread10339723misrea_d
misrely12319613misre_ly
missal84314903mis_sal_
missays124010253mis_says
misseat93617243missea_t
missel85216523misse_l_
missends11368233missends
misses85130873misse__s
missets94516573misse_ts
misspeaks1743063misspeaks
misspells1343763misspells
misteach1545443misteach
mistends11419593mistends
misterms123711353misterms
misters93927513miste_rs
mistral91013643mistral_
mistreats1148633mistreats
mistrials1148133mistrials
modals93914453m_od_als
models94216353m_ode_ls
musicals1247093musicals
mussels9419843musse_ls
ordeals877993_ordeals
pineals93212843pi_neals
reseals73917663res_eals
seals54839693__s_eals
sheals94420643__sheals
sisals63013573sis__als
steals64020063__steals
unseals73212573uns_eals
visuals1036853vis_uals
wiseass1035823wis_eass

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 Filter1786911461620.423422437.4
2DLD Change Limit1461621147.12620511.1
3Display Results1141140.0462478.3
 (SQL Overall)1786911147.59523527.5
 
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.