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

89 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
distrust94994(None) 
distrusts1046521distrusts
mistrust1049201mistrust
destruct1148382destruct
diestrus946522diestrus_
disgust937632dis_gust
disrupt1048632dis_rupt
distract11313022distract
distrait9414342distrait
distress9311712distress
district11413872district
distrusted1246292distrusted
intrust7311492_intrust
mistrusts1146012mistrusts
mistryst1345842mistryst
abstruse1065513abstruse
bistres94017213bistres_
bistros92810983bistros_
cistus84611343cist_us_
citrus83610923ci_trus_
citrusy12284183ci_trusy
destructs1245773destructs
diarist8517113di_arist
dictiest113212783dictiest
diestrous1046603diestrous_
diestrum1145363diestru_m
diestrums1244413diestrums
diestruses1164503diestruses
dioestrus1043933dioestrus_
direst75024243di__rest
dirtiest93014203dirtiest
disabuse1145553disabuse
disarms1039043disarms_
disburse1186443disburse
discount11811313discount
discreet11413183discreet
discus94512113dis_cus_
discuss10357953dis_cuss
diseurs839403diseurs_
diseuse83110723dis_euse
disgusts1045653dis_gusts
dishiest12313683dishiest
dismast10311233dis_mast
dismount1188223dismount
disroot8413563dis_root
disrupts1145293dis_rupts
distant83519953dist_ant
distaste939943dist_aste
distent84120853dist_ent
distils83015803distils_
distinct11410763distinct
distort81120333dist_ort
distorts91112353distorts_
distracts1249283distracts
distrain9412243distrain
distraint101112903distraint
distraite10611483distraite
distraught1552773distraught
districts1248933districts
distrustful1582333distrustful
distrusting1386493distrusting
disturb1046233dist_urb
disturbs1145403disturbs
disuse74012843dis__use
ditsiest92111323ditsiest
dustiest93015073dustiest
entrust7410883_entrust
estrus61912113_estrus_
incrust949203_incrust
instruct1047543instruct
intrusts837723_intrusts
mistiest103018313mistiest
mistreat10313113mistreat
mistress10310703mistress
mistrusted1345433mistrusted
mistruth1346043mistruth
mistrysts1443863mistrysts
obstruct1246033obstruct
oestrus7169583oestrus_
piecrust1244633piecrust
pistous92714383pistous_
ristras7311563ristras_
sistrum946563sistru_m
sistrums1055313sistrums
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.406440125.6
2DLD Change Limit146162896.92021121.7
3Display Results89890.0501780.0
 (SQL Overall)178691897.37624226.0
 
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.