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

101 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
distract1131302(None) 
distracts1249281distracts
distrait9414341distrait
district11413871district
abstract1249222abstract
destruct1148382destruct
detract101414632d_etract
diffract1744722diffract
disgrace1248282disgrace
distant83519952dist_ant
distinct11410762distinct
distracted1448872distracted
distrain9412242distrain
distraint101112902distraint
distraite10611482distraite
districts1248932districts
distrust949942distrust
mistrace12312642mistrace
abstracts1346593abstracts
abstrict1257943abstrict
astrict9614793_astrict
attract9511833_attract
contract122915633contract
destructs1245773destructs
detracts11138833d_etracts
diastral946993diastra_l
didact10711203di__dact
diffracts1843223diffracts
diktat11310693dikt_a_t
direct93817333di__rect
disbranch1744383disbranch
discant103017263dis_cant
discreet11413183discreet
disfrock1843303disfrock
disgraced1446743disgraced
disgracer1346183disgracer
disgraces1348453disgraces
dishrag1246273dishra_g
dishrags1346203dishrags
disject17268673dis_ject
disjunct1843963disjunct
dismast10311233dis_mast
dispart101115283dis_part
displace1348653displace
displant11412223displant
disrate81418523dis_rate
disroot8413563dis_root
disrupt1048633dis_rupt
disseat83816923dissea_t
dissect103614133dis_sect
distaff1467683dist_aff
distain8313783dist_ain
distal73615773dist_a_l
distance11311853distance
distaste939943dist_aste
distent84120853dist_ent
distich13312173dist_ich
distort81120333dist_ort
distracting1569253distracting
distraction1449113distraction
distractive1746773distractive
distrains10411333distrains
distraints1166873distraints
distraught1552763distraught
distress9311713distress
districted1448223districted
distrusts1046523distrusts
dustrag945363dustra_g
dustrags1044943dustrags
extract16311013_extract
infract12610003_infract
instruct1047543instruct
intact8314663_int_act
interact10316473_interact
intrant7318753_intrant
misact10316693mis__act
misgraft1447203misgraft
misteach1545443misteach
mistraced1439453mistraced
mistraces13312293mistraces
mistrain10311943mistrain
mistral91013643mistra_l
mistrals101212623mistrals
mistreat10313113mistreat
mistrust1049203mistrust
mistryst1345843mistryst
obstruct1246033obstruct
ostraca937823_ostraca
postrace12310543postrace
protract12510603protract
redistrict1355703redistrict
restrict10313633restrict
retract91318113_retract
ristra6310713ristra__
ristras7311563ristra_s
sistra639333sistra__
strait64025893__strait
strict84821043__strict
subtract1249583subtract
titrant7315193ti_trant
tract75635713___tract

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 Limit1461621016.68621860.9
3Display Results1011010.0462195.7
 (SQL Overall)1786911017.17224915.1
 
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.