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

446 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
deceit9301821(None) 
deceits102810881deceits
decent94023701decent
dacoit9415452dacoit
debit85727852de_bit
decant93524222decant
deceive1337812deceive
decern91310952decern
decoct11313782decoct
decrepit1345882decrepit
deet57356582de_e_t
defeat103817162defeat
defect124816172defect
deject164512842deject
dement93825152dement
demerit10314992demerit
demit84832302de_mit
descent102616292descent
desert72725492desert
detect94217402detect
detent73624482detent
detest74122842detest
devein1039142devein
devest104418702devest
docent92918682docent
receipt1159252receipt
recent83630852recent
recept103319082recept
recit75235102rec_it
accent105116263accent
accept123210633accept
aecia73819283aec_ia
albeit8314343albeit
ascent84519653ascent
becket144619883becket
bedsit9312843bedsit
beet66457543be_e_t
befit105222663be_fit
beget85632563bege_t
behest11314613behest
benefit1248073benefit
bereft114317303bereft
beret74946363bere_t
beset76739133bese_t
bewept13410323bewept
cecity1398153cec_ity
ceil65725063__ceil
celt65646713__celt
cement103321673cement
cent67451013__cent
chit96937463__chit
conceit113218073conceit
crit65743713__crit
dace76934923dace__
daces85030683dace_s
dacite91115883dac_ite
dacoits1079073dacoits
dacoity1366183dacoity
dakoit11310353dakoit
dammit11311133dammit
davit93424593d_avit
daylit10512493daylit
deadest93014883deadest
deafest112911513deafest
deair65817193de_air
dealt65234283de_alt
dearest83618673dearest
dearie73319813dearie
deasil71110983deasil
debeak1336763debeak
debits94214503de_bits
debris93311493debris
debt77139023d__ebt
debut86024143de_but
decade104216163decade
decadent1249003decadent
decaf114919443dec_af
decafs124010883decafs
decal85523233dec_al
decals93717713decals
decamp1338453decamp
decane93818873decane
decants103514443decants
decare93919153decare
decay114718483dec_ay
decays124612913decays
decease1049523decease
decedent12310213decedent
deceitful1552533deceitful
deceived1535893deceived
deceiver1436233deceiver
deceives1437903deceives
decemvir1641963decemvir
decency1537453decency
decennia1144223decennia
decenter112412163decenter
decently1448013decently
decentre11248553decentre
decerns10119053decerns
decide104116873decide
decile94619213decile
deck115827753dec__k
decked145217623decked
deckel134911043deckel
deckels14367363deckels
decker135215993decker
deckers144413833deckers
decking153915593decking
deckle1312012453deckle
decks124822193dec_ks
declaim1247363declaim
declaw1266703declaw
decline103716613decline
deco76125973dec__o
decocts1237833decocts
decode104414743decode
decor84717573dec_or
decors94017773decors
decos85522123dec_os
decoy115716313dec_oy
decoys123911283decoys
decree93117783decree
decreed112710263decreed
decreer10269123decreer
decrees102513123decrees
decrial10310323decrial
decried112612863decried
decrier102713563decrier
decries103319813decries
decry115514353dec_ry
decrypt1545703decrypt
decury1277963decury
deduct10610793deduct
dee47665823de_e__
deed65340903de_e_d
deeds75423763de_eds
deedy104315893de_edy
deem75432893de_e_m
deems85421773de_ems
deep76031883de_e_p
deepest10310443deepest
deeps84921773de_eps
deer56739023de_e_r
deers64930523de_ers
dees56356633de_e_s
deets65330243de_ets
defat95426693de_fat
defeats113511233defeats
defects134511523defects
defend113910493defend
defer94619753defe_r
defers105116943defers
deffest14308813deffest
defi86321493de_fi_
deficit1339683deficit
defied115016383defied
defier105118653defier
defies104624053defies
defis96717503de_fis
deflect13399973deflect
deft85540223d__eft
deftest112611713deftest
degerm1037893degerm
degust8310253degust
dehort104618103dehort
deice84320033deice__
deiced104214483deice_d
deicer94114413deice_r
deicers103612733deicers
deices94119373deice_s
deictic1237703deictic
deific1237313deific
deil56231623d__eil
deist64633593de_ist
deity94316773d__eity
deixis1437243deixis
dejecta17376363dejecta
dejects17389223dejects
deke95228763deke__
deked115718533deke_d
dekeing13358353dekeing
dekes105224453deke_s
dele56843083dele__
delead84112343delead
deled75326543dele_d
deleing93313953deleing
deles65139253dele_s
delete73620703delete
delft95623323de_lft
deli55631293de_li_
delict94320333delict
delimit10311733delimit
delis64928543de_lis
delist74625053delist
delt57855273d__elt
deltic9312503deltic
demast9517063demast
deme76536283deme__
demean9510563demean
dements103016623dements
demerits11310763demerits
demes86032693deme_s
demic105119193de_mic
demies94825803demies
demits94918073de_mits
dene56643413dene__
denes65639723dene_s
deni56929393de_ni_
denied84318633denied
denier74420693denier
denies74729643denies
denim85518843de_nim
densest83112473densest
density1137593density
dent57158413d__ent
dentil74017883dentil
dentin73919573dentin
dentist8316743dentist
deorbit1048173deorbit
depaint10314593depaint
depart94720563depart
depend103510923depend
deperm1139363deperm
depict113514793depict
deport94922393deport
deposit10313003deposit
depot85727923de_pot
derail74218813derail
derat65044083de_rat
dere56845903dere__
derelict11138483derelict
dermic114511913dermic
dermis94717163dermis
derris73615273derris
desalt7518313desalt
descant104315593descant
descend11248153descend
descents112511203descents
deserts82513053deserts
desex13311983dese_x
desist74818813desist
desmid1048363desmid
despite10410123despite
despot93413293despot
dessert82916453dessert
detail74516433detail
detain74617383detain
detects104011093detects
detente83313603detente
detents83615153detents
deter65028043dete_r
deters74724683deters
detests83711743detests
deuce84517493deuce__
deuced104112123deuce_d
deuces94015513deuce_s
deveins1138813deveins
devel94217123deve_l
devels104313903devels
devests114410473devests
devil94714733de_vil
devoid1189363devoid
devoir1076033devoir
devout10712993devout
dewed105020303dewe_d
dewier104013463dewier
dewiest11312343dewiest
dexes135224513dexe_s
dexie134716893de_xie
dexies145018343dexies
dicast9315573dicast
dice75841903dice__
diced95824683dice_d
dicer85426423dice_r
dicers94720743dicers
dices86434243dice_s
dicey114819333dice_y
dicier94416233dicier
diciest103316523diciest
dickie133913113dickie
dicot85429093dic_ot
diet57357543d_ie_t
digest84019623digest
digit73825273d_igit
dimwit1237953dimwit
direct93817333direct
direst75024243direst
discept12310623discept
dit47071343d___it
divert103922813divert
divest106820073divest
dixit134420593d_ixit
docents102810803docents
docetic1239913docetic
docket134721173docket
doest65829523d_oest
doit56347853d__oit
drest65530343d_rest
driest74722753driest
droit65127123d_roit
dryest104811123dryest
ducat86225903duc_at
duce76933503duce__
duces86327473duce_s
duci76422623duc_i_
duckie133511663duckie
duct75735463duc__t
duecento1143563duecento
duet56446263d_ue_t
duit56241583d__uit
dulcet9314493dulce_t
duvet9321873duve_t
dwelt94316523d_welt
dynein1035563dynein
ecesic10369223_ecesic
ecesis84611203_ecesis
echt95722903_ec_ht
eclat7523603_eclat
edit54934873_e_dit
egest65222343_egest
eject145016043_eject
elect74327033_elect
elegit71212893_elegit
emit65438423_e_mit
erect74129333_erect
event85924443_event
evert84929513_evert
except1797653except
exert124624143_exert
exit114428673_e_xit
facet106038523face_t
feces105625363fece_s
feet75352213fe_e_t
fewest12311663fewest
feyest12311403feyest
geest64829623ge_est
genet66038683gene_t
gerent73223103gerent
hectic132311523hectic
henbit111412003henbit
hereat93527413hereat
herein93717793herein
hermit11519443hermit
incent83320723incent
incept102712763incept
incest82918743incest
indecent11411273indecent
jesuit1339583jesuit
keet85347353ke_e_t
lectin82515013lectin
leet45957903le_e_t
legit61323503le_git
licit74327683lic_it
lucent8313823lucent
meet65350553me_e_t
merest84725113merest
merit7339183me_rit
nereid7312933nereid
nereis6315343nereis
newest9314213newest
nicest82315663nicest
nocent83217413nocent
oncet74626543once_t
orcein838183orcein
pectic122913873pectic
pectin102615533pectin
peewit111110903peewit
percent113520603percent
percept133112523percept
pereia85217983pereia
permit10321683permit
petit74332653pe_tit
pewit104622793pe_wit
precent113520263precent
precept133112513precept
rebait8320403rebait
recant83228683recant
recast83422773recast
recede95515533recede
receipts1274693receipts
receive1239733receive
recepts113010273recepts
recess8314263recess
recheat12415933recheat
recite83625113rec_ite
recits83621353rec_its
recoat84024273recoat
recoil84016723recoil
recoin84320293recoin
recruit939773recruit
recti73619623recti_
recut74729243rec_ut
reedit7617223reedit
reemit8717223reemit
reest54938093re_est
refect114319333refect
refelt94521423refelt
refit84230063re_fit
regent74127673regent
reheat94423943reheat
reject154116283reject
reknit10312533reknit
relent64431853relent
relet54749823rele_t
relit55340683re_lit
remeet86325473remeet
remelt85123123remelt
remet74843723reme_t
remit75737223re_mit
renest64529713renest
repeat85127213repeat
repent84728873repent
rerent63832453rerent
reseat64131493reseat
resect84424703resect
resent63833623resent
reset55051863rese_t
resit54241043re_sit
retest64028453retest
revert93529113revert
revest94623603revest
revet84938843reve_t
rewet85135153rewe_t
scent75831623_scent
secant84023293secant
secede93311993secede
secern81010223secern
secret8325063secret
sect67443623sec__t
select82621173select
sennit63117923sennit
serein63318463serein
serest64831613serest
sobeit8315363sobeit
tacet75840023tace_t
tacit76333673tac_it
techie11511723techie
tectite9310583tectite
tenet55542213tene_t
tercet83624913terce_t
territ63421383territ
wecht13415443wec_ht
weest85026773we_est
weet75254153we_e_t
weskit1338343weskit
zechin20137703zechin

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 Filter1786911127160.670266703.0
2DLD Change Limit1127164465.87619182.4
3Display Results4464460.1403185.7
 (SQL Overall)1786914466.68626726.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.