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

121 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
disject1726867(None) 
disjects18275921disjects
dissect103614131dissect
bisect10312872bis_ect
deject164512842d_eject
dialect101210262dialect
direct93817332di_rect
discept12310622discept
disjected2086352disjected
disjunct1843962disjunct
disseat83816922disseat
dissects11279242dissects
dissent84018682dissent
dissert83720692dissert
distent84120852distent
inject153210232_inject
abject17137703_abject
aspect10612823_aspect
bisects1137133bis_ects
defect124816173d_efect
deflect13399973deflect
dejecta17376363d_ejecta
dejects17389223d_ejects
descent102616293descent
deselect1147523deselect
desert72725493des_ert
dessert82916453dessert
detect94217403d_etect
dialects11126003dialects
diciest103316523diciest
didact10711203di_dact
diet57357533di__e_t
digest84019623di_gest
diluent8310263diluent
dimmest1249253dimmest
dioecy1235543di_oecy
dipnet91317473dipne_t
directs102710263di_rects
direst75024243di_rest
disaffect1873103disaffect
disc76123233dis__c_
discant103017253discant
disced104914653disce_d
discepts1336743discepts
discern1038493discern
disci85815023dis__ci
disco85616073dis__co
discreet11413183discreet
discs85316263dis__cs
diseur738843dis_eur
disgust937633disgust
dished114318713dishe_d
dishelm1335833dishelm
disherit12412523disherit
dishes104622653dishe_s
dishiest12313683dishiest
disinfect1545043disinfect
disjecting2177243disjecting
disjoin1547643disjoin
disjoint1649233disjoint
disjuncts1942723disjuncts
disked125015763diske_d
diskette1346753diskette
dismast10311233dismast
disme85716243disme__
dismes95617673disme_s
dispart101115283dispart
dispel9310323dispe_l
dispels10310503dispels
dispend11289413dispend
disport101015953disport
disroot8413563disroot
disrupt1048633disrupt
disseats93211503disseats
dissected13108663dissected
dissector1245523dissector
dissed85220183disse_d
dissents93411863dissents
disserts92411813disserts
disses75225963disse_s
distant83519953distant
distend93312073distend
distich13312173distich
distinct11410763distinct
distort81120333distort
distract11313023distract
district11413873district
ditsiest92111323ditsiest
divert103922813di_vert
divest106820073di_vest
eject145016043__eject
exsect1558503exs_ect
idiolect1144353idiolect
infect113413443_infect
injects16257453_injects
insect83916583_insect
inspect1138463inspect
islet54527553_isle_t
kismet123414623kisme_t
misact10316683mis_act
miseat82925703mis_eat
miskept1538923miskept
mismeet113215163mismeet
mismet103722373misme_t
misseat93617233misseat
missent94318713missent
misset85028153misse_t
object17135803_object
project1838453project
reeject16349623reeject
reinject1745543reinject
reject154116283_reject
resect84424703res_ect
respect11412033respect
sect67443623__s_ect
subject18258633subject
suspect1158513suspect
traject1637043traject
trisect939733tris_ect
wisent93516343wis_ent
wisest95016443wis_est

Search took 7 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 Filter1786911340270.406440125.6
2DLD Change Limit1340271216.48320673.6
3Display Results1211210.0462630.4
 (SQL Overall)1786911216.93525766.5
 
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.