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

124 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
mistuning123767(None) 
listening10128952listening
misatoning1346442misatoning
miscuing1338732miscu_ing
misruling1237492misruling
mistaking1699692mistaking
mistending1447952mistending
mistiming1438912mistiming
misting103623382mist__ing
mistyping1744722mistyping
misusing1138892mis_using
moistening1346232moistening
attuning935903_attuning
costuming1445283costuming
destining11311433destining
disowning1446113disowning
disputing1337763disputing
distaining1248903distaining
distancing1447083distancing
distending1348333distending
disturbing1445653disturbing
disusing1039013dis_using
fastening13268603fastening
fissuring1344813fissuring
fisting113818123fist__ing
fortuning1345493fortuning
gesturing1136653gesturing
glistening1294283glistening
hastening13259483hastening
histing113720373hist__ing
intoning9311123_intoning
issuing836053_issu_ing
kittening1434593kittening
listing84020593list__ing
masoning1139763mas_oning
mastering122315313mastering
masting104325823mast__ing
maturing1139963m_aturing
miaouing1134893miaou_ing
miauling1137343mi_auling
mildening1345673mildening
milting103619123milt__ing
mining94225453mi___ning
minting103020813mint__ing
minuting1139723mi_nuting
misacting1439083misacting
misadding14115833misadding
misaiming1437873misaiming
misbinding1645063misbinding
misciting1439673misciting
miscoding1538183miscoding
miscoining1597763miscoining
miscounting1646053miscounting
miscutting1576053miscutting
misdating131010663misdating
misdoing1238803mis_doing
miseating121215433miseating
misfiling1537223misfiling
misfiring1536973misfiring
misgauging1543903misgauging
misgiving1645593misgiving
misguiding1544343misguiding
misjoining2085293misjoining
misjudging2242783misjudging
mislaying1557913mislaying
misliking1637113misliking
misliving1546983misliving
mislying1437843mis_lying
mismaking18118023mismaking
mismating141211823mismating
mismoving1745783mismoving
misnaming1447423misnaming
mispaging1537803mispaging
mispenning1545773mispenning
misquoting2244363misquoting
misrating121014853misrating
misrouting1347223misrouting
missaying1537633missaying
missending1446493missending
missing103619073mis__sing
missioning1347403missioning
missounding1543443missounding
misstating13129313misstating
misstyling1643833misstyling
missuiting1356743missuiting
misterming1538603misterming
misthink1745433mist_hink
misthinking2143423misthinking
mistitling1346223mistitling
mistouching1942993mistouching
mistracing1569603mistracing
mistrain10311943mistrain_
mistraining1446503mistraining
mistrains11511353mistrains
mistrusting1465923mistrusting
mistune9310653mistu__ne
mistuned1157723mistun_ed
mistunes10311133mistun_es
mistutoring1442823mistutoring
misunion1084943mis_union
misunions1154533mis_unions
misyoking1944923misyoking
mitering113015403mi_tering
mitring103514143mi_t_ring
mustering122212333mustering
musting103221073must__ing
mutining11310493m_utining
pasturing1238433pasturing
picturing1436033picturing
pistoling1268493pistoling
posturing1238993posturing
retuning9311583_retuning
sistering101213753sistering
staning83922243__staning
stoning83717443__stoning
stunning9298463__stunning
stunting92811503__stunting
tissuing935103tissu_ing
tittuping1242453tittuping
tuning74016843___tuning
untuning937943_untuning
vesturing1337203vesturing
visioning1347063visioning
wisting113519743wist__ing

Search took 9 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.450397091.1
2DLD Change Limit1486411247.76619140.0
3Display Results1241240.0631968.3
 (SQL Overall)1786911248.27921583.6
 
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.