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

266 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
rectum10341128(None) 
rectums11338521rectums
rectus83314631rectus
tectum10328601tectum
acetum1038462acetum
aecium10410422aecium
cecum11611842cec_um
centum104012362centum
dictum1136862dictum
mentum104511712mentum
recoup10810372recoup
recta74220262rect_a
rectal84418132rectal
recti73619622rect_i
recto74520802rect_o
rector84019742rector
rectos85718782rectos
recur74116842rec_ur
recut74729242rec_ut
recuts83817372recuts
regnum957162regnum
retem74221952re_tem
rictus8379192rictus
septum1038002septum
tectums11306422tectums
adytum1243733adytum
argentum1145363argentum
becalm1239203becalm
begum105213923be_gum
bestud9439303bestud
brecham1646833brecham
cactus104912233cactus
caecum1238183caec_um
centrum1168603centrum
centu76119413centu_
centums11398783centums
cerium10313763cerium
cesium1039583cesium
cestus84412913cestus
chum116318003__chum
cum76440163__c_um
datum8310633_datum
decorum1246943decorum
degum94711903de_gum
dictums1235553dictums
ecru65819533_ecru_
ecrus75113863_ecrus
ecu56828233_ec_u_
ecus65421463_ec_us
electrum1245213electrum
erbium1038083erbium
erect74129333erect__
erected103213993erected
erecter93113393erecter
erectly1257483erectly
erector93513803erector
erects84116183erect_s
erratum944503erratum
estrum81810513_estrum
etui45416233_e_tui
ferrum1147453ferrum
fetus85816543fe_tus
fractur12135563fractur
fractus12146593fractus
frenum1188803fre_num
frustum1243953frustum
getup83410263ge_tup
geum75424553ge__um
hectic132311523hectic
hector113312653hector
helium112311253helium
ictus7249703_ictus
lactam10310943lactam
lectin82515013lectin
lector83514983lector
lecture9149513lecture
letup73712163le_tup
locum94812173loc_um
lyceum1343953lyceum
meatus85112923meatus
medium113711623medium
metump1235713me_tump
nectar838853nectar
neum66723083ne__um
notum7611693_notum
oestrum9177783oestrum
omentum1155933omentum
orectic1138823orectic
pecten102711103pecten
pectic122913873pectic
pectin102615533pectin
peplum12156823peplum
plectrum1453953plectrum
precoup1336123precoup
precut102016533prec_ut
precuts111710473precuts
premium13310363premium
racism103214193racism
radium93513293radium
ramentum1244863ramentum
react74634333react__
reacted103015713reacted
reactor93011653reactor
reacts83616603react_s
realm75621623re_alm
ream65841613re__am
rearm75923563re_arm
reata54225393reat_a
reatas64021013reatas
rebus75721113re_bus
rebut75927383re_but
rebuts84015193rebuts
rebuy104714683re_buy
rec55645463rec___
recall83815723recall
recane83022873recane
recant83228683recant
recap95718023rec_ap
recaps103615733recaps
recast83422773recast
recce9514563rec_ce
recces10614913recces
recede95515533recede
recent83630853recent
recept103319073recept
recess8314263recess
rechew14310213rechew
recipe103414893recipe
recit75235103rec_it
recital9412163recital
recite83625113recite
recited104319103recited
reciter94117263reciter
recites93524583recites
recits83621353recits
reck106130563rec__k
recked134821803recked
reckon123010543reckon
recks115625133rec_ks
reclad9311873reclad
reclaim1137753reclaim
reclame11411063reclame
recluse95210773recluse
recoal84117973recoal
recoat84024273recoat
recock145112723recock
recode93618713recode
recoil84016723recoil
recoin84320293recoin
recomb1238873recomb
recon75624243rec_on
recons84922993recons
recook125513923recook
recopy1339043recopy
record96117423record
recork126315483recork
recount9315173recount
recoupe11109933recoupe
recoups1188843recoups
recruit939773recruit
recs65734183rec__s
rectify1536453rectify
rectors93520513rectors
rectory123512723rectory
rectrix1645363rectrix
recurs83315803recurs
recuse85519163recuse
redbud10135803redbud
redbug10165473redbug
redeem9311523redeem
redout71820253redout
redtop937973redtop
redub84212413re_dub
redux133811103re_dux
refilm114311403refilm
reflux16315413reflux
reform11312703reform
reft75141273reft__
refute95515703refute
regius7311923regius
reglue739703reglue
rehem103815353re_hem
relume8313273re_lume
rem56150043re___m
rent46661243rent__
rental63922023rental
rente54733783rent_e
rented74426593rented
renter64527413renter
rentes65431193rentes
rents55935183rent_s
reoccur1143353reoccur
replumb1343393replumb
repour8310993repour
repump1235683re_pump
repute84716093repute
rerun58722153re_run
rescue8313003rescue
rest46459843rest__
restamp1146483restamp
rested74430783rested
rester63832433rester
restful1038623restful
rests54935873rest_s
restudy1144763restudy
restuff1346953restuff
resume8313783re_sume
ret35982833re_t__
retag63618413re_tag
retax124517973re_tax
retch104818303re_tch
rete44944133re_t_e
reteam83214533reteam
retems83914573re_tems
retia55326113re_tia
retie55735303re_tie
retime85321803re_time
retrim83514883retrim
retro55020953re_tro
retry84718083re_try
rets45352563re_t_s
retted74826313retted
retune69121953re_tune
return623222523re_turn
retuse66617223re_tuse
revue81114453re_vue
rewarm115913483rewarm
rhenium1246243rhenium
rheum1038843r_heum
rhythm1742883rhythm
rictal83113183rictal
rostrum947213rostrum
ruckus12407793ruckus
rum56644643r___um
sacrum103910143sacrum
sanctum1145293sanctum
scrum95418193_scrum
scum85924523_sc_um
scutum1036373scutum
sebum93814553se_bum
sect67443623sect__
sector83415923sector
sects75622893sect_s
sedum84115573se_dum
sensum849353sensum
septums1135743septums
serum75223473se_rum
setup73915823se_tup
spectrum1444073spectrum
sputum1035943sputum
stum65526023__stum
tecta74215523tect_a
tectal83713253tectal
tedium9269873tedium
telium82611393telium
tergum937933tergum
tetotum9134613tetotum
uredium1076693uredium
vacuum1334833vacuum
vector113212063vector
vellum1136773vellum
velum10713383ve_lum
vertu85017613vertu_
vertus94613603vertus
victim1337693victim
zoecium2044183zoecium

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 Filter1786911127160.453394461.4
2DLD Change Limit1127162667.84314371.5
3Display Results2662660.0932860.2
 (SQL Overall)1786912668.38921300.6
 
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.