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

226 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
rectums1133852(None) 
rectum103411281rectum_
rectus83314631rectu_s
tectums11306421tectums
centums11398782centums
dictums1235552dictums
recoups1188842recoups
rectors93520522rectors
rectos85718782rect_os
recurs83315802rec_urs
recuts83817372rec_uts
retems83914572re_tems
rictus8379192rictu_s
septums1135742septums
tectum10328602tectum_
acetum1038463acetum_
aecium10410423aecium_
argentums1243873argentums
becalms1335743becalms
begums11429493be_gums
bestuds10326753bestuds
brechams1745773brechams
cactus104912233cactu_s
cecum11611843cec_um_
centrums1236913centrums
centum104012363centum_
ceriums1139473ceriums
cesiums1136303cesiums
cestus84412913cestu_s
chums125015833__chums
datums936353_datums
decorums1344993decorums
degums10438623de_gums
dictum1136863dictum_
ecrus75113863_ecru_s
ecus65421463_ec_u_s
electrums1344483electrums
erbiums1135463erbiums
erecters102611613erecters
erectors103514263erectors
erects84116183erect__s
estrums9208603_estrums
etuis54013133_e_tuis
ferrums1265983ferrums
fetus85816543fe_tu_s
fracturs13146313fracturs
fractus12146593fractu_s
frenums1236203fre_nums
frustums1342993frustums
getups9346853ge_tups
geums85414113ge__ums
hectors123513263hectors
heliums12188303heliums
ictus7249703_ictu_s
lactams1136953lactams
lectins92515003lectins
lectors93415763lectors
lecture9149513lecture
lectures101310153lectures
letups8317683le_tups
locums10478303loc_ums
lyceums1442403lyceums
meatus85112923meatu_s
mediums12308723mediums
mentum104511713mentum_
metump1235713me_tump
metumps1334133me_tumps
nectars938463nectars
neums75414253ne__ums
oestrums10156473oestrums
omentums1243973omentums
pectens11189203pectens
pectins112315233pectins
peplums13145503peplums
plectrums1553033plectrums
precuts111710473prec_uts
premiums1437533premiums
racisms112310813racisms
radiums10299313radiums
reactors103212283reactors
reacts83616603react__s
realms84913493re_alms
reams75729623re__ams
rearms85114653re_arms
reatas64021013reat_as
rebus75721113re_bu_s
rebuts84015193re_buts
rebuys11428783re_buys
recalls92613623recalls
recanes93222263recanes
recants93217093recants
recaps103615733rec_aps
recasts93413533recasts
recces10614913rec_ces
recedes102816063recedes
recepts113010263recepts
recess8314263rec_ess
rechews1537293rechews
recipes113314463recipes
recitals1039763recitals
reciters102613113reciters
recites93524583recites
recits83621353rec_its
reckons13269653reckons
recks115625133rec__ks
reclads1049993reclads
reclaims1236113reclaims
reclame11411063reclame
reclames12310893reclames
recluse95210773recluse
recluses105111733recluses
recoals94214623recoals
recoats92616643recoats
recocks154711463recocks
recodes102918633recodes
recoils93814873recoils
recoins94019243recoins
recomb1238873rec_omb
recombs1336753recombs
recons84922993rec_ons
recooks134711233recooks
records105213923records
recorks134813023recorks
recount9315173recount
recounts1038773recounts
recoup10810373recou_p
recoupe11109933recoupe
recourse1038383recourse
recross989833recross
recruit939773recruit
recruits1036563recruits
recs65734183rec___s
recta74220263rect__a
rectal84418133rect_al
recti73619623rect__i
rectify1536453rectify
recto74520803rect__o
rector84019753rect_or
rectory123512733rectory
rectrix1645363rectrix
recur74116843rec_u_r
recuse85519163rec_use
recuses94619463recuses
recut74729243rec_u_t
redbuds11144283redbuds
redbugs11134463redbugs
redeems1037163redeems
redouts81411663redouts
redtops1037373redtops
redubs9358383re_dubs
refilms12347503refilms
reforms1239823reforms
refutes104515733refutes
regius7311923regiu_s
reglues838713reglues
regnum957163regnum_
rehems113410983re_hems
relume8313273re_lume
relumes9612513re_lumes
rems66237723re___ms
rentals74017473rentals
renters74224813renters
rentes65431193rent_es
rents55935183rent__s
reoccurs1242963reoccurs
replumb1343393replumb
replumbs1442183replumbs
repours9310233repours
repump1235683re_pump
repumps1334403re_pumps
reputes94615963reputes
reruns66413743re_runs
rescues9312753rescues
restamp1146483restamp
restamps1234703restamps
resters74130403resters
rests54935873rest__s
restudy1144763restudy
restuff1346953restuff
restuffs1444193restuffs
resume8313783re_sume
resumes9313373re_sumes
retags73414303re_tags
retches123318513retches
reteams9339563reteams
retem74221953re_tem_
reties65436193re_ties
retime85321803re_time
retimes95020173re_times
retrims93612373retrims
retros63820193re_tros
rets45352563re_t__s
retune69121953re_tune
retunes76918403re_tunes
return623222523re_turn
returns79712593re_turns
retuse66617223re_tuse
revues9813903re_vues
rewarms12439603rewarms
rheniums1344413rheniums
rheums1135463r_heums
rhythms1842553rhythms
rictuses1037563rictuses
rostrums1046083rostrums
ruckus12407793rucku_s
rums64833473r___ums
sacrums11388043sacrums
sanctums1244013sanctums
scrums104614253_scrums
scums95017423_sc_ums
sebums10369813se_bums
sectors93116453sectors
sects75622893sect__s
sedums93910483se_dums
septum1038003septum_
serums83916303se_rums
setups83910463se_tups
spectrums1543173spectrums
stums75320083__stums
tediums10266973tediums
tetotums10124063tetotums
vacuums1443403vacuums
vectors123212593vectors
vellums1235293vellums
vertus94613603vertu_s
victims1436003victims

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.406440125.6
2DLD Change Limit1340272266.59320328.7
3Display Results2262260.0932430.1
 (SQL Overall)1786912267.09225196.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.