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

395 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
recepts11301026(None) 
precepts14268881precepts
receipts1274691receipts
recept103319071recept_
accepts13356352accepts
deceits102810882deceits
excepts1885202excepts
incepts11238282incepts
percepts14247642percepts
precents123015032precents
precept133112512precept_
reaccepts1583212reaccepts
recants93217092recants
recaps103615732recap_s
recasts93413532recasts
recedes102816062recedes
receipt1159252receipt_
recent83630852recent_
receptor1256692receptor
receptors1356912receptors
recess8314262rece_ss
recheats1339192recheats
recipes113314462recipes
recits83621352rec_its
recoats92616642recoats
recuts83817372rec_uts
reests64618892re_ests
refects124012742refects
regents83416542regents
reheats104513522reheats
rejects163910692rejects
relents74018502relents
relets64025672rele_ts
remeets93712412remeets
remelts93511492remelts
renests74014212renests
repeats94316052repeats
repents93717622repents
rerents73319422rerents
reseats74319582reseats
resects94115592resects
resents74221222resents
resets65427612rese_ts
retests73813852retests
reverts104715042reverts
revests104413732revests
revets94022172reve_ts
rewets94617212rewe_ts
accents113511233accents
accept123210623accept_
adepts9117103_adepts
ascents93812553ascents
becaps123811403becap_s
beckets15399823beckets
beeps95320973be_ep_s
beets76131443be_e_ts
begets96215523bege_ts
behests1235953behests
berets85822523bere_ts
besets85718803bese_ts
bewept13410323bewept_
biceps12447713bicep_s
brevets12519393breve_ts
celts75325783__celts
cements112714223cements
cents74730333__cents
cepes94424463__cepes
ceps86125953__cep_s
concepts143110303concepts
creeps104213623cre_ep_s
crescents1367533crescents
decants103514443decants
deceit93018213deceit_
decent94023703decent_
decerns10119053decerns
decocts1237833decocts
decrypts1642943decrypts
deeps84921773de_ep_s
deets65330243de_e_ts
defeats113511233defeats
defects134511523defects
dejects17389223dejects
dements103016623dements
descents112511203descents
deserts82513053deserts
detects104011093detects
detents83615153detents
detests83711743detests
devests114410473devests
discepts1336743discepts
docents102810803docents
ecesis84611203_ecesis
eclats8313033_eclats
egests74411253_egests
ejects15409953_ejects
elects83315003_elects
erects84116183_erects
erupts8348903_erupts
events94814073_events
everts94514893_everts
except1797653except_
excerpts1943743excerpts
exempts1844023_exempts
exerts133712293_exerts
facets116316653face_ts
feces105625363fece__s
geests75912163ge_ests
genets75716663gene_ts
gerents82612923gerents
greets75117423gre_e_ts
incents92414533incents
incept102712753incept_
incests92711383incests
jeeps144715373je_ep_s
keeps116020283ke_ep_s
keets95123483ke_e_ts
keleps12478813kelep_s
kreeps12427413kre_ep_s
leets54927123le_e_ts
meets74224613me_e_ts
metepas1136303metepas
neeps75617883ne_ep_s
peeps95822363pe_ep_s
percents122713363percents
percept133112523percept_
precasts1239453precasts
precedes13310703precedes
precent113520253precent_
preceptor1547313preceptor
preceptors1657033preceptors
precess11310863prece_ss
precipes143212213precipes
precuts111710473prec_uts
preempts1444543preempts
prefects1598133prefects
preheats1339413preheats
prelects1299723prelects
presents103315633presents
presets94216423prese_ts
pretests10310013pretests
pretexts1735603pretexts
prevents133012293prevents
racemes1139093racemes
racers84725433race_rs
races74943243race__s
rachets124516833rachets
racists92613323racists
rackets134916873rackets
ramets83517393rame_ts
reaccents1365853reaccents
reaccept1465123reaccept_
reacts83616603re_acts
readapts1145583readapts
readopts1146483readopts
reagents959623reagents
reapers93520453reapers
reaps75626193re_ap_s
reascents1177393reascents
rebaits9312573rebaits
rebecks15288013rebecks
rebecs103913673rebe_cs
rebels84518133rebe_ls
reboots93512093reboots
rebops10311423rebop_s
rebuts84015193re_buts
recalls92613613recalls
recanes93222263recanes
recant83228683recant_
recap95718023recap__
recarpets1344383recarpets
recast83422773recast_
recces10614913rec_ces
recede95515533rece_de
receded112713043receded
receipted1445333receipted
receiptor1343493receiptor
receiptors1443653receiptors
receive1239733receive
receives1339743receives
recements13312283recements
recency1438623recency
recenter102715443recenter
recentest11410283recentest
recently1339423recently
reception13410303reception
receptions1449713receptions
receptive1648313receptive
recesses10312323recesses
recharts1337663recharts
recheat12415933recheat_
rechecks1944553rechecks
rechews1537293rechews
recipe103414893recip_e
recit75235103rec_it_
recite83625113rec_ite
recites93524583recites
reckons13269653reckons
recks115625133rec__ks
reclads1049993reclads
recleans1037513recleans
recoals94214623recoals
recoat84024273recoat_
recocks154711463recocks
recodes102918633recodes
recoils93814873recoils
recoins94019243recoins
recombs1336753recombs
recons84922993rec_ons
recooks134711233recooks
recopies12313723recopies
recopy1339043recop_y
records105213923records
recorks134813023recorks
recounts1038773recounts
recoups1188843recoups
recrate92621643recrate
recrates102420353recrates
recreants1146623recreants
recreate10313603recreate
recreates11313343recreates
recross989833recross
recruits1036563recruits
recs65734183rec___s
recta74220263rec__ta
recti73619623rec__ti
recto74520803rec__to
rectors93520513rectors
rectos85718783rec_tos
rectums11338523rectums
rectus83314633rec_tus
recurs83315803rec_urs
recuses94619463recuses
recut74729243rec_ut_
redacts10510943redacts
redcaps1247073redcap_s
redcoats1147123redcoats
redears82814453redears
redeems1037163redeems
redes65139123rede__s
redeyes112910973redeyes
redips93713843redip_s
redipt94116743redipt_
redouts81411653redouts
reedits8511743reedits
reeds65430903re_e_ds
reefs85121663re_e_fs
reejects17336083reejects
reeks94124033re_e_ks
reelects103110883reelects
reels55333263re_e_ls
reemits9611303reemits
reerects10319923reerects
rees45364193re_e__s
reest54938093re_est_
reeves94721493re_eves
refect114319333refect_
refeeds11368973refeeds
refeels10379693refeels
refels94618053refe_ls
refelt94521423refelt_
refers93921083refe_rs
refits94017653re_fits
reflects13288873reflects
reflets103513153reflets
regears83012463regears
regent74127673regent_
reges65628783rege__s
reglets83512983reglets
regreets9287853regreets
regrets83212923regrets
rehears103312773rehears
reheat94423943reheat_
reheels10298253reheels
rehems113410983rehe_ms
reject154116283reject_
rekeys13347693reke_ys
reknits1137073reknits
reknots1136783reknots
relends84013253relends
relent64431853relent_
relet54749823rele_t_
releves103914973releves
relicts94414593relicts
relists73817053relists
relucts9369673relucts
remaps105012873remap_s
remeet86325473remeet_
remelt85123123remelt_
remends105013033remends
remet74843723reme_t_
remints95117293remints
remits85622943re_mits
reneges82513593reneges
renest64529713renest_
renews93811753rene_ws
rennets75212633rennets
rents55935183r__ents
reopens939373reopens
repasts93611933repasts
repeals94014523repeals
repeat85127213repeat_
repegs93311943repe_gs
repels84318763repe_ls
repent84728873repent_
reperks13298093reperks
replots93412633replots
reports94916213reports
repos74725793r__epos
repots85621003re_pots
repps95114343r__epps
reps65937953r__ep_s
requests1735743requests
rereads81512293rereads
reredos838633reredos
rerent63832453rerent_
rerepeats1145253rerepeats
rescripts1374573rescripts
resculpts1343283resculpts
reseals73917663reseals
reseat64131493reseat_
reseaus74012153reseaus
resect84424703resect_
resedas839123resedas
reseeds84012333reseeds
reseeks11348623reseeks
resees63827483rese_es
resells73313203resells
resends83513713resends
resent63833623resent_
reset55051863rese_t_
resews94814173rese_ws
resifts10378703resifts
resists74414923resists
resits64725563re_sits
resmelts1046143resmelts
resorts74817193resorts
respects1247703respects
respots92912763respots
rests54935873r__ests
results739833results
retapes93917423retapes
reteams9339563reteams
retears72814923retears
retells73211523retells
retems83914573rete_ms
retenes76324623retenes
retest64028453retest_
retints74717013retints
retorts76016513retorts
retreats8311403retreats
rets45352563r__e_ts
retypes12308623retypes
reveals103812723reveals
revels94220573reve_ls
reverbs12368863reverbs
reveres103621343reveres
revers94529633reve_rs
revert93529113revert_
revest94623603revest_
revet84938843reve_t_
revolts1038893revolts
rewears102911033rewears
reweds104412303rewe_ds
rewelds11457413rewelds
rewet85135153rewe_t_
rexes124526953rexe__s
rezeros1647453rezeros
ricers84120993rice_rs
rices75536153rice__s
rickets134915093rickets
rivets94417113rive_ts
rochets124213473rochets
rockets134615363rockets
rodents8611543rodents
rosets65819953rose_ts
scents85317023_scents
secants93413893secants
secedes103711983secedes
secerns987733secerns
secrets9311773secrets
sects75622893sec__ts
seeps74828753se_ep_s
selects91912143selects
septs75420603__septs
tempts10439453te_mpts
tenets65518953tene_ts
tercets93512443terce_ts
trecento1066213trecento
trecentos1155863trecentos
trevets10499973treve_ts
triceps11267343tricep_s
veeps104715723ve_ep_s
wechts1446253wec_hts
weeps104120563we_ep_s
weets85427723we_e_ts

Search took 9 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 Limit1340273958.11016526.1
3Display Results3953950.1402821.4
 (SQL Overall)1786913958.40621257.6
 
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.