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

97 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
district1141387(None) 
distract11313021distract
districts1248941districts
abstrict1257942abstrict
astrict9614792_astrict
destruct1148382destruct
distich13312172dist_ich
distinct11410762distinct
distracts1249292distracts
distraint101112902distraint
distrait9414342distrait
districted1448222districted
distrust949952distrust
redistrict1355712redistrict
restrict10313632restrict
strict84821042__strict
abstract1249223abstract
abstricts1355183abstricts
astricts1049463_astricts
bistroic1246383bistroic_
citric102812313ci_tric_
constrict13711623constrict
deistic10311173deist_ic_
destrier9311823destrier
destructs1245773destructs
detract101414633d_etract
diarist8517113di_arist
diatribe1145673diatribe
diffract1744733diffract
digastric1343623digastric_
digastrics1442643digastrics
dimeric12310023dimeric_
dimetric1348663dimetric_
dineric10310973dineric_
dioptric1345633dioptric_
dioptrics1444103dioptrics
dipstick1775223dipst_ick
direct93817333di__rect
discreet11413183discreet
disfrock1843303disfrock
disgrace1248283disgrace
disherit12412523disheri_t
disject17268673dis_ject
disjoint1649233disjoint
disjunct1843963disjunct
disomic1238763disomic_
disorient10412523disorient
dispirit1149203dispirit
disprize2048433disprize
disquiet1879933disquiet
disroot8413563dis_root
disrupt1048633dis_rupt
dissect103614133dis_sect
distain8313783distai_n
distains9413603distains
distance11311853distance
distant83519953dist_ant
distent84120853dist_ent
distichs1447633dist_ichs
distil73616433dist_i_l
distill83011323dist_ill
distils83015803dist_ils
distort81120333dist_ort
distracted1448873distracted
distrain9412243distrain
distrains10411343distrains
distraints1166883distraints
distraite10611483distraite
distress9311713distress
distribute13145523distribute
districting1559013districting
distrusts1046533distrusts
dysuric1344533dysuric_
fistic11812573fist_ic_
gastric1038643gastric_
historic1388943historic_
iatric8312173_iatric_
instruct1047543instruct
misprice1448133misprice
misprint12912973misprint
mistrace12312643mistrace
mistreat10313113mistreat
mistrial10311383mistrial
mistrust1049203mistrust
mistryst1345843mistryst
miswrit1249413miswri_t
nitric82512063ni_tric_
obstruct1246033obstruct
ostrich1238663_ostrich
postriot10412253postriot
redistricts1453673redistricts
restricts1138823restricts
strick124813203__strick
stript85222193__stript
subdistrict1652703subdistrict
vitric112510113vi_tric_
vitrics12198553vi_trics

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.440406115.9
2DLD Change Limit146162977.09320606.5
3Display Results97970.0462108.7
 (SQL Overall)178691977.57923577.1
 
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.