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

118 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
dismasts113751(None) 
dismast10311231dismast_
demasts1089222d_emasts
dicasts1078702di_casts
discants112912022discants
discases112014502discases
diseases92415812diseases
disgusts1045652disgusts
dismals102010242disma_ls
dismasted1346832dismasted
dismays13237432disma_ys
dismiss1038152dismis_s
disparts11109952disparts
distaste939942distaste
distastes1039632distastes
durmasts1144092durmasts
kismats13257842kisma_ts
miscasts1238342miscasts
biomass1155993biomas_s
cineasts1045543cineasts
cosmists1237993cosmists
damasks1435073d_amasks
demast9517063d_emast_
desalts839573des_alts
descants112910143descants
desists83611723des_ists
desmans1039003desma_ns
diabases1137223diabases
dialists9411413dialists
diamante1186423diamante
diamantes1296263diamantes
diarists9410363diarists
diastases1047073diastases
dicast9315573di_cast_
didacts1186063di_dacts
digamists1345003digamists
digests93610613di_gests
diktats1235623dikta_ts
dimmest1249253dimmest_
dimouts1037893di_mouts
dimwits1344513di_mwits
diquats1745983diqua_ts
disarms1039043dis_arms
disaster949943dis_aster
disasters1039153dis_asters
disbands1237353disbands
disbars10310323disba_rs
discant103017253discant_
discards1238913discards
discase102912863discas_e
discased122510853discased
discepts1336743discepts
discuses113112863discuses
discuss10357953discus_s
disdains1037913disdains
disease83213843diseas_e
diseased103011713diseased
diseuses93112763diseuses
disgust937633disgust_
disjects18275923disjects
dismal92412243disma__l
dismaler1137903dismaler
dismalest1246313dismalest
dismally1446513dismally
dismantle1245043dismantle
dismantles1344333dismantles
dismasting1446383dismasting
dismay12229473disma__y
dismayed1535743dismayed
dismes95617673dism__es
dismisses1245503dismisses
dismounts1275283dismounts
dispart101115283dispart_
displants1248073displants
disports111111113disports
disposes11313823disposes
disrate81418523disra_te
disrates91118153disrates
disroots948623disroots
disrupts1145293disrupts
dissaves1239413dissaves
disseats93211503disseats
dissects11279243dissects
dissents93411863dissents
disserts92411813disserts
disses75225963dis__ses
distaffs1565083distaffs
distains9413603distains
distant83519953distant_
distasted1137963distasted
distaves12311403distaves
distorts91112353distorts
distracts1249283distracts
distrusts1046523distrusts
disuses84015413dis_uses
divests114510933di_vests
durmast1037623durmast_
dynasts1155103d_ynasts
kismat123011673kisma_t_
kismets13306883kism_ets
mainmasts1343483mainmasts
masts77035763___masts
midmosts1343773midmosts
misacts1139353mis_acts
miscast11312413miscast_
miseases102614343miseases
miseats92815783misea_ts
mismakes16129883mismakes
mismarks1645893mismarks
mismate111415353misma_te
mismates121114563mismates
mismeets12297733mismeets
misparts12108173misparts
pissants1097363pissants
smalts85214893__smalts
smarts86218003__smarts
topmasts1244963topmasts
wiseass1035823wiseas_s

Search took 10 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.1561145455.1
2DLD Change Limit1461621189.25015801.3
3Display Results1181180.0631873.0
 (SQL Overall)1786911189.46918871.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.