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

84 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
dismasted134683(None) 
distasted1137961distasted
demasted1238762d_emasted
disaster949942dis_aster
discanted1339332discanted
discased122510852discas_ed
diseased103011712diseas_ed
disgusted1246122disgusted
dismantled1443692dismantled
dismast10311232dismast__
dismasts1137512dismast_s
dismayed1535742disma_yed
dismissed1344612dismissed
disparted1338852disparted
disrated10915572disra_ted
distaste939942distaste_
distastes1039632distastes
mismated131111332misma_ted
damasked1643753d_amasked
desalted1038313des_alted
descanted1336673descanted
desisted1039783des_isted
diamante1186423diamante_
diamantes1296263diamantes
diastem10318043di__astem
diaster82813313di__aster
dictated1239203dicta_ted
digested11208163di_gested
dilated93115823di_la_ted
disabled1248713dis_abled
disarmed1238643dis_armed
disasters1039153dis_asters
disbanded1445643disbanded
disbarred1345273disbarred
discalced1545653discalced
discarded1437083discarded
discase102912863discas_e_
discases112014503discas_es
discepted1547523discepted
discussed13256763discussed
disdained1246023disdained
disease83213843diseas_e_
diseases92415813diseas_es
disjected2086353disjected
dismaler1137903disma_ler
dismantle1245043dismantle
dismantles1344333dismantles
dismasting1446383dismasting
dismisses1245503dismisses
dismounted1445413dismounted
displanted14126633displanted
disported13310303disported
disposed12310943dispos_ed
disputed1238353dis_puted
disrate81418523disra_te_
disrates91118153disra_tes
disrooted1147623disrooted
disrupted1345973disrupted
dissaved1337313dissa_ved
disseated11711083disseated
dissected13108663dissected
dissed85220183dis__s_ed
dissented1199723dissented
disserted11109813disserted
distained1139603distained
distanced1348573distanced
distorted1139373distorted
distracted1448873distracted
distrusted1246293distrusted
disunited1177273disunited
disused93211033dis_us_ed
disvalued1444193disvalued
divested13268213di_vested
impasted13297553_impasted
masted94025803___masted
misacted1338673mis_acted
misdated121211123misda_ted
mismarked1845243mismarked
mismate111415353misma_te_
mismates121114563misma_tes
misparted1437263misparted
misrated111315383misra_ted
smarted105012613__smarted
smashed133711223__smashed

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 Filter1786911486410.406440125.6
2DLD Change Limit148641847.03321134.8
3Display Results84840.0302800.0
 (SQL Overall)178691847.46923924.4
 
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.