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

430 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
refects12401274(None) 
defects134511521defects
prefects1598131prefects
refect114319331refect_
reflects13288871reflects
rejects163910691rejects
resects94115591resects
affects1535392affects
defeats113511232defeats
defect124816172defect_
deflects14336732deflects
dejects17389222dejects
detects104011092detects
effects1535282effects
ejects15409952_ejects
elects83315002_elects
erects84116182_erects
infects12279712infects
perfects15107352perfects
praefects1642872praefects
prefect141011072prefect_
prelects1299722prelects
reacts83616602re_acts
rebecks15288012rebecks
rebecs103913672rebec_s
recepts113010262recepts
redacts10510942redacts
redefects1543792redefects
reejects17336082reejects
reelects103110882reelects
reerects10319922reerects
reests64618892re_ests
refaces123216742refaces
refected142311662refected
refeeds11368972refeeds
refeels10379692refeels
refels94618052refe_ls
refelt94521422refelt_
refences13311842refences
refers93921082refe_rs
refits94017652ref_its
reflect123913712reflect_
reflets103513152reflets
refocus1236972refocus
refracts13137382refracts
regents83416542regents
reheats104513522reheats
reinfects1444722reinfects
reject154116282reject_
relents74018502relents
relets64025672rele_ts
relicts94414592relicts
relucts9369672relucts
remeets93712412remeets
remelts93511492remelts
renests74014212renests
repeats94316052repeats
repents93717622repents
rerents73319422rerents
reseats74319582reseats
resect84424702resect_
resents74221222resents
resets65427612rese_ts
respects1247702respects
retests73813852retests
reverts104715042reverts
revests104413732revests
revets94022172reve_ts
rewets94617212rewe_ts
selects91912142selects
advects13276013advects
affect1448903affect_
artefacts1443153artefacts
aspects1146743aspects
bedecks1635793bedecks
beets76131443be_e_ts
befits114711503bef_its
beflecks1943753beflecks
befrets1237613befrets
begets96215523bege_ts
behests1235953behests
berets85822523bere_ts
besets85718803bese_ts
bisects1137133bisects
brevets12519393breve_ts
cements112714223cements
coeffects1942463coeffects
coerects1258543coerects
confects153110873confects
deceits102810883deceits
decocts1237833decocts
deducts1166593deducts
deets65330243de_e_ts
defaces133213403defaces
defats105114553def_ats
defeat103817163defeat_
defecate1438793defecate
defecates1538593defecates
defected15289973defected
defector14277953defector
defectors15237883defectors
defences1439633defences
defends12358773defends
defers105116943defe_rs
deficits1447273deficits
deflect13399973deflect_
defocus1335283defocus
deject164512843deject_
dejecta17376363dejecta
delicts104012253delicts
dements103016623dements
depicts12358463depicts
deserts82513053deserts
detect94217403detect_
detents83615153detents
detests83711743detests
devests114410473devests
directs102710263directs
edicts94911703_edicts
educts9439893_educts
effect1437443effect_
efts76519483_ef__ts
egests74411253_egests
eject145016043_eject_
ejecta15337393_ejecta
elect74327033_elect_
enacts84012973_enacts
epacts105010393_epacts
erect74129333_erect_
eructs83610793_eructs
events94814073_events
everts94514893_everts
evicts11368553_evicts
exacts15359613_exacts
execs14539723_exec_s
exerts133712293_exerts
expects1866883expects
exsects1655573exsects
facts107021893__facts
feats86432753__feats
feces105625363__feces
fecks145417853__fecks
felts85324543__felts
fests85828043__fests
fets75345943__fe_ts
geests75912163ge_ests
genets75716663gene_ts
gerents82612923gerents
greets75117423gre_e_ts
hefts116218153hef__ts
infect113413443infect_
infests10279793infests
inflects1336193inflects
injects16257453injects
insects93710843insects
jefes155613673jefe__s
keets95123483ke_e_ts
leets54927123le_e_ts
lefts86517813lef__ts
meets74224613me_e_ts
neglects1144383neglects
objects18123693objects
perfect141010833perfect_
perfecta15115203perfecta
perfectas16135073perfectas
perfecto15105743perfecto
perfectos16106073perfectos
praefect1544773praefect_
praelects1354353praelects
preacts113211363pre_acts
precents123015043precents
precepts14268893precepts
predicts1339613predicts
preelects1356083preelects
preerects1345413preerects
prefaces15311063prefaces
prefers123713333prefe_rs
prefocus1544743prefocus
preheats1339413preheats
prelect111013833prelect_
presents103315643presents
presets94216423prese_ts
pretests10310013pretests
pretexts1735603pretexts
prevents133012293prevents
projects1936413projects
prosects1239473prosects
protects1239743protects
rafts87820633raf__ts
ramets83517393rame_ts
react74634333re_act_
reagents959623reagents
rebaits9312573rebaits
rebec94416543rebec__
rebeck14419913rebec_k
rebels84518133rebe_ls
reboots93512093reboots
rebuts84015193re_buts
recants93217093recants
recasts93413533recasts
recces10614913re_cces
recedes102816063recedes
receipts1274693receipts
recent83630853recent_
recept103319073recept_
recess8314263rece_ss
recheats1339193recheats
rechecks1944553rechecks
recits83621353re_cits
recks115625133r__ecks
recoats92616643recoats
recocks154711463recocks
recs65734183r__ec_s
recta74220263r__ecta
recti73619623r__ecti
recto74520803r__ecto
rectos85718783r__ectos
rectus83314633r__ectus
recuts83817373re_cuts
redact9419043redact_
redears82814453redears
redeems1037163redeems
redefeats1344203redefeats
redefect1446053redefect_
redes65139123rede__s
redeyes112910973redeyes
redirects12125103redirects
rednecks1544013rednecks
redocks14409933redocks
redouts81411663redouts
reduces10513343reduces
reecho11318653re_echo
reechy14367823re_echy
reedits8511743reedits
reeds65430903re_e_ds
reefers103312593reefers
reefs85121663re_e_fs
reeject16349623reeject_
reeks94124033re_e_ks
reelect911515633reelect_
reels55333263re_e_ls
reemits9611303reemits
reenacts1036993reenacts
reerect92915883reerect_
rees45364193re_e__s
reest54938093re_est_
reeves94721493re_eves
reface113616353refac_e
refaced133713573refaced
refalls103312243refalls
refecting152413353refecting
refection141512283refection
refections151811643refections
refective1749113refective
refectory1746023refectory
refed93921923refe__d
refeed104717623refe_ed
refeel93913243refe_el
refel84920813refe__l
refell94214443refe_ll
refence12312233refence
refenced1438993refenced
refer84822143refe__r
referee101615753referee
referees111310413referees
referents12259643referents
refights1555883refights
refiles104122423refiles
refills103711423refills
refilms12347503refilms
refinds114512123refinds
refines105426343refines
refires104820313refires
refit84230063ref_it_
refixes174813173refixes
reflags1156953reflags
reflate103516263reflate
reflates113115663reflates
reflected1547983reflected
reflector1445733reflector
reflectors1545503reflectors
reflet94024233reflet_
reflexes1865923reflexes
reflies104418533reflies
refloats1156913refloats
reflows13258983reflows
refolds11298953refolds
reforests1245533reforests
reforms1239813reforms
refract121311603refract_
refries104419733refries
refronts1137773refronts
refs75732243ref___s
reft75141273ref__t_
refuels10399523refuels
refuges115413373refuges
refunds11448623refunds
refuses104918553refuses
refute95515703ref_ute
refutes104515723refutes
regears83012463regears
regent74127673regent_
reges65628783rege__s
reglets83512983reglets
regreets9287853regreets
regrets83212923regrets
rehears103312773rehears
reheat94423943reheat_
reheels10298253reheels
rehems113410983rehe_ms
reinfect1346483reinfect_
reinjects1844023reinjects
rejected182710113rejected
rejectee17289623rejectee
rejectees18235423rejectees
rejecter17258943rejecter
rejecters18257543rejecters
rejector17237723rejector
rejectors18247613rejectors
rekeys13347693reke_ys
reknits1137073reknits
reknots1136783reknots
relaces93420883relaces
relends84013253relends
relent64431853relent_
relet54749823rele_t_
releves103914973releves
relics84517903relic_s
relict83623903relict_
relists73817053relists
relocks134411293relocks
reluct83916113reluct_
remeet86325473remeet_
remelt85123123remelt_
remends105013033remends
remet74843723reme_t_
remints95117293remints
remits85622943re_mits
reneges82513593reneges
renest64529713renest_
renews93811753rene_ws
rennets75212633rennets
rents55935183r__ents
reobjects2062003reobjects
repacks15269543repacks
repasts93611933repasts
repeals94014523repeals
repeat85127213repeat_
repegs93311943repe_gs
repels84318763repe_ls
repent84728873repent_
reperks13298093reperks
replots93412633replots
reports94916213reports
repots85621003re_pots
requests1735743requests
reracks132310533reracks
rereads81512293rereads
reredos838633reredos
rerent63832453rerent_
reseals73917663reseals
reseat64131493reseat_
reseaus74012153reseaus
resected112514743resected
resedas839123resedas
reseeds84012333reseeds
reseeks11348623reseeks
resees63827483rese_es
reselects1156413reselects
resells73313203resells
resends83513713resends
resent63833623resent_
reset55051863rese_t_
resews94814173rese_ws
resifts10378703resifts
resists74414923resists
resits64725563re_sits
resmelts1046143resmelts
resorts74817193resorts
respect11412033respect_
respots92912763respots
rests54935873r__ests
results739833results
retacks132210713retacks
reteams9339563reteams
retears72814923retears
retells73211523retells
retems83914573rete_ms
retenes76324623retenes
retest64028453retest_
retints74717013retints
retorts76016513retorts
retracts101111313retracts
retreats8311413retreats
rets45352563r__e_ts
reveals103812723reveals
revels94220573reve_ls
reverbs12368863reverbs
reveres103621343reveres
revers94529633reve_rs
revert93529113revert_
revest94623603revest_
revet84938843reve_t_
revolts1038893revolts
rewears102911033rewears
reweds104412303rewe_ds
rewelds11457413rewelds
rewet85135153rewe_t_
rexes124526953rexe__s
rezeros1647453rezeros
rifest93114583rifest_
rifts85718643rif__ts
rivets94417113rive_ts
rodents8611543rodents
rosets65819953rose_ts
sects75622893__sects
select82621173select_
senecas939013senecas
tenets65518953tene_ts
tercets93512443tercets
trajects1744533trajects
trevets10499973treve_ts
trifecta1343573trifecta
trifectas1443653trifectas
trisects1035983trisects
weets85427723we_e_ts
wefts116715493wef__ts
xebecs17355363xebec_s
zebecks24274193zebecks
zebecs19316183zebec_s

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 Limit1340274308.09316560.9
3Display Results4304300.1562756.4
 (SQL Overall)1786914308.40521260.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.