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 “mustangs” 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
mustangs1125597(None) 
mustang10267931mustang_
dustings10419032dustings
hustings12378682hustings
muntings11289812muntings
musings10389542mus_ings
mustards11297882mustards
musting103221072musting_
mutants938582mu_tants
stangs75018172__stangs
bastings114214693bastings
buntings11348773buntings
bushings14348793bushings
busings103711223bus_ings
bussings11386663bussings
bustards11308513bustards
busting104221793busting_
butanes9312743bu_tanes
castings113614053castings
custards11338393custards
cuttings11277613cuttings
ductings12346673ductings
dusting93618993dusting_
dustpans1143233dustpan_s
dustrags1044943dustrags
eastings93412953eastings
fastings124011943fastings
fustians1146403fustian_s
gusting93917163gusting_
huntings12328053huntings
husbands1444763husbands
huskings16276043huskings
instants8910153instants
jestings16368023jestings
justing153615163justing_
lastings94214423lastings
listings93310043listings
lusting83619323lusting_
lustrings10245553lustrings
lutings83311053lu_tings
mahuangs1452883mahuangs
maskings15448753maskings
mastabas1246803mastabas
masting104325823masting_
matings104516213m_atings
mattings11369673mattings
meetings11287413meetings
messans92710463messan_s
mestinos1048163mestinos
mistakes141213413mistakes
mistends11419593mistends
misting103623383misting_
mistunes10311133mistunes
montanes101114523montanes
moshings14367333moshings
mountings12266163mountings
mousings11277703mous_ings
mudstones1245033mudstones
muggings13244593muggings
munting103718773munting_
muntins92715133muntin_s
muscats1138933musca_ts
mushing134217633mushing_
musing93919503mus_ing_
muskegs14285013mus_kegs
muslins9312213muslin_s
mussing104015543mussing_
mustache15185283mustache
mustaches16166053mustaches
mustard10359533musta_rd
mustardy14265053mustardy
mustees94614923must_ees
musters94522513must_ers
musths11589483must__hs
mustiness112211663mustiness
musts75527443must___s
mutant8317693mu_tan_t
mutases92012043mu_tases
mutates92215793mu_tates
mutines93117823mu_tines
muting93921523mu_ting_
mutons84314363mu_ton_s
muttons949283mutton_s
mystagogs1652173mystagogs
nuttings9276783nuttings
ourangs8318503ou_rangs
ousting84021353ousting_
outings84014753ou_tings
outsang83411273outsang_
outsings93410333outsings
outstands1045543outstands
postings112912303postings
rushings12387843rushings
rusting83821263rusting_
satangs8479713_satangs
slangs75615343__slangs
stags66226743__sta_gs
staigs75414813__staigs
stands75118053__stands
stanes64933403__stanes
stang66424693__stang_
stanks104917703__stanks
stings76220183__stings
suitings9288953suitings
sultanas8237153sultanas
sultans72411833sultan_s
suntans72111733suntan_s
sustains838553sustains
tangs65028363___tangs
tuftings12264323tuftings
unhangs1136203_unhangs
upstands1144093upstands
vestings12359143vestings
westings12429803westings

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 Filter1786911461620.423422437.4
2DLD Change Limit1461621146.32623105.0
3Display Results1141140.0462478.3
 (SQL Overall)1786911146.79526297.4
 
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.