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

86 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
mistrust104920(None) 
distrust949951distrust
mistrusts1146011mistrusts
mistryst1345841mistryst
distrusts1046532distrusts
intrust7311492_intrust
mistiest103018312mistiest
mistreat10313112mistreat
mistress10310702mistress
mistrusted1345432mistrusted
mistruth1346042mistruth
mistrysts1443862mistrysts
abstruse1065513abstruse
bistres94017213bistres_
bistros92810983bistros_
cistus84611343cist_us_
citrus83610923ci_trus_
citrusy12284183ci_trusy
destruct1148383destruct
diestrus946533diestrus_
disgust937643dis_gust
disrupt1048633dis_rupt
distract11313023distract
distrait9414343distrait
distress9311713distress
district11413873district
distrusted1246293distrusted
entrust7410883_entrust
estrus61912113_estrus_
incrust949203_incrust
instruct1047543instruct
intrusts837723_intrusts
metrist9317063m_etrist
miltiest103015173miltiest
mintiest103217143mintiest
misadjust1952123misadjust
miscast11312423mis_cast
miscount1299473miscount
miscut10614823mis_cu_t
miscuts1139183mis_cuts
misdoubt1394073misdoubt
misers85025703miser_s_
misgraft1447203misgraft
misprint12912973misprint
misrule939353mis_rule
missout9412663missou_t
missouts1037623missouts
misstruck1762523misstruck
missuit9911303mis_suit
missus85312293mis_sus_
mistaught1543543mistaught
misterms123711353misterms_
misters93927513misters_
misteuk1335893misteu_k
mistouch1543803mistouch
mistrace12312643mistrace
mistrain10311943mistrain
mistral91013643mistr_al
mistrals101212633mistrals
mistreats1148633mistreats
mistrial10311383mistrial
mistrustful1661623mistrustful
mistrusting1465923mistrusting
mistruths1443683mistruths
mistrysted1643633mistrysted
mists76633903mist__s_
mistune9310653mist_une
misuse83213643mis__use
miswrit1249413miswr_it
mitiest93520053mi_tiest
mitres83922073mi_tres_
moistest1038763moist_est
mostest9314793most_est
mustiest103017533mustiest
obstruct1246033obstruct
oestrus7169583oestrus_
piecrust1244633piecrust
pistous92714383pistous_
ristras7311563ristras_
sistrum946563sistru_m
sistrums1055323sistrums
strunt64918913__strunt
strut56030733__stru_t
struts65616803__struts
trust55426853___trust
unitrust845563unitrust

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 Limit146162867.45319611.2
3Display Results86860.0302866.7
 (SQL Overall)178691867.90622601.9
 
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.