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

65 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
distrusts104652(None) 
distrust949941distrust_
mistrusts1146011mistrusts
destructs1245772destructs
diestruses1164502diestruses
disgusts1045652dis_gusts
disrupts1145292dis_rupts
distracts1249282distracts
distress9311712distres_s
districts1248932districts
distrusted1246292distrusted
intrusts837722_intrusts
mistrust1049202mistrust_
mistrysts1443862mistrysts
cistuses1038283cist_uses
citruses1037483ci_truses
destruct1148383destruct_
diarists9410363di_arists
diestrums1244413diestru_ms
diestrus946523diestru__s
dioestruses1262343dioestruses
disabuses1246203disabuses
disburses1266743disburses
discounts1287823discounts
discuses113112863dis_cuses
discuss10357953dis_cus_s
diseuses93112763dis_euses
disgust937633dis_gust_
dismasts1137513dis_masts
dismounts1275283dismounts
disroots948623dis_roots
disrupt1048633dis_rupt_
distaste939943dist_aste
distastes1039633dist_astes
distorts91112353dist_orts
distract11313023distract_
distrains10411333distrains
distraints1166873distraints
distrait9414343distrait_
distraite10611483distraite
distresses1148853distresses
district11413873district_
distrustful1582333distrustful
distrusting1386493distrusting
disturbs1145403dist_urbs
disuses84015413dis__uses
entrusts847113_entrusts
estruses838483_estruses
incrusts1036253_incrusts
instructs1145793instructs
intrust7311493_intrust_
mistreats1148633mistreats
mistress10310703mistres_s
mistrusted1345433mistrusted
mistruth1346043mistru_th
mistruths1443683mistruths
mistryst1345843mistryst_
obstructs1344573obstructs
oestruses946403oestruses
piecrusts1342603piecrusts
sistrums1055313sistru_ms
strunts7429543__strunts
struts65616803__stru_ts
trusts64714433___trusts
unitrusts943323unitrusts

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.470380193.6
2DLD Change Limit148641657.90318808.2
3Display Results65650.0331969.7
 (SQL Overall)178691658.40621257.6
 
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.