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

139 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
discept1231062(None) 
discepts1336741discepts
descent102616292descent
discant103017252discant
disced104914652disce_d
discepted1547522discepted
discern1038492discern
discreet11413182discreet
disject17268672disject
disrupt1048632disrupt
disseat83816922disseat
dissect103614132dissect
dissent84018682dissent
dissert83720692dissert
distent84120852distent
incept102712752_incept
miskept1538922miskept
accept123210623_accept
ascent84519653_ascent
bicep115413543bi_cep_
biceps12447713bi_ceps
biscuit1147373biscuit
bisect10312873bis_ect
concept133314443concept
deceit93018213d_eceit
decent94023703d_ecent
dehiscent1545483dehiscent
descant104315583descant
descend11248153descend
descents112511203descents
desert72725493des_ert
dessert82916453dessert
dialect101210263dialect
dicast9315573di_cast
dice75841893di_ce__
diced95824683di_ce_d
dicer85426423di_ce_r
dicers94720743di_cers
dices86434243di_ce_s
dicey114819333di_ce_y
diciest103316523diciest
dicot85429093di_c_ot
diet57357533di__e_t
digest84019623di_gest
diluent8310263diluent
dimmest1249253dimmest
diocese1036853diocese
dipnet91317473dipne_t
dipt77339323di___pt
direct93817333di_rect
direst75024243di_rest
disc76123233disc___
discants112912023discants
discard11310213discard
discase102912863discase
discepting1658473discepting
discerns1138163discerns
disci85815023disc__i
discing113914593discing
disciple1346673disciple
disco85616073disc__o
discoed11312483discoed
discoid11311243discoid
discord1139993discord
discos94915213disc_os
discount11811313discount
discovert1548793discovert
discredit1345363discredit
discrepant1554243discrepant
discrete11410283discrete
discs85316263disc__s
discus94512113disc_us
discuss10357953discuss
diseur738843dis_eur
disgust937623disgust
dished114318713dishe_d
dishelm1335833dishelm
disherit12412523disherit
dishes104622653dishe_s
dishiest12313683dishiest
disjects18275923disjects
disked125015763diske_d
diskette1346753diskette
dismast10311233dismast
disme85716243disme__
dismes95617673disme_s
dispart101115283dispart
dispel9310323dispe_l
dispels10310503dispels
dispend11289413dispend
disport101015953disport
disrepute12144933disrepute
disroot8413563disroot
disrupts1145293disrupts
disseats93211503disseats
dissects11279243dissects
dissed85220173disse_d
dissents93411863dissents
disserts92411813disserts
disses75225963disse_s
distant83519953distant
distend93312073distend
distort81120333distort
ditsiest92111323ditsiest
divert103922813di_vert
divest106820073di_vest
docent92918683d_ocent
dulcet9314493dulce_t
except1797653_except
incent83320723_incent
incepts11238283_incepts
incest82918743_incest
inept73622153_i_nept
inswept1245733inswept
islet54527553_isle_t
kismet123414623kisme_t
miscast11312403miscast
miscopy1636663miscopy
miscut10614813misc_ut
miseat82925703mis_eat
mismeet113215163mismeet
mismet103722373misme_t
misseat93617233misseat
missent94318713missent
misset85028153misse_t
nascent9610523nascent
nicest82315663ni_cest
percept133112523percept
precept133112513precept
recept103319073_recept
scent75831623__scent
sept65844363__s_ept
slept75728103__slept
swept105720603__swept
unswept1246013unswept
upswept1443473upswept
viscera1235083viscera
wisent93516343wis_ent
wisest95016443wis_est

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340271397.14018771.3
3Display Results1391390.0463021.7
 (SQL Overall)1786911397.34224338.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.