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

104 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
vacuum133483(None) 
vacuums1443401vacuums
baculum1345702baculum
sacrum103910142sacrum
vacua10510462vac_ua
vacuous1237022vacuous
vacuumed1641592vacuumed
vasculum1542982vasculum
acetum1038463_acetum
acute74720363_acute
aecium10410423aecium
album92312653_album
algum82711763_algum
alum65227613_a_lum
arum66129033_a_rum
aurum7614963_aurum
backup1646613backup
bacula103112673bacula
baculums1443723baculums
barium10313513barium
cactus104912233cactus
caecum1238183caecum
calcium1368593calcium
caucus1039613caucus
cecum11611843cec_um
chum116318003__chum
culm85822383__culm
cum76440163__c_um
dadgum1134583dadgum
datum8310633da_tum
dictum1136863dictum
evacuee12105073evacuee
faceup1334893faceup
facula112912233facula
fanum10313443fa_num
gaum75726423ga__um
haulm104415413ha_ulm
kalium1239473kalium
labium10410243labium
labrum1057423labrum
lactam10310943lactam
lacuna8118123lacuna
lacune8169673lacune
larum74317973la_rum
locum94812173loc_um
lyceum1343953lyceum
macula103013673macula
macule104115273macule
magnum1136733magnum
oakum1177313oa_kum
osculum1143833osculum
pablum1237503pablum
pabulum1344473pabulum
racism103214193racism
radium93513293radium
rectum103411283rectum
sacbut10811943sacbut
sachem134012223sachem
sacque17107113sacque
sacrums11388043sacrums
sagum8512873sa_gum
sanctum1145293sanctum
scrum95418203_scrum
scum85924523_sc_um
scutum1036373_scutum
talcum1036953talcum
tectum10328603tectum
vac86537143vac___
vacant11415133vacant
vacate11314553vacate
vacs96226203vac__s
vacuity1545763vacuity
vacuole1245373vacuole
vacuuming1741903vacuuming
vagrom1235943vagrom
vague96513113va_gue
vaguer10448443vaguer
vagus96713813va_gus
valgus1047103valgus
valour93010373valour
value85719093va_lue
valued104011153valued
valuer93911443valuer
values94314943values
valuta938743valuta
vapour11378873vapour
varoom11411413varoom
varus85921183va_rus
vascula1245853vascula
vasculums1642143vasculums
vatful12107083vatful
vatu76524333va_tu_
vatus86114643va_tus
vau66840873va__u_
vault85823763va_ult
vaunt85925313va_unt
vaus75928923va__us
vellum1136773vellum
velum10713383v_elum
victim1337693victim
vicuna11115903vicuna
vinculum1542763vinculum
vum85428653v___um
wampum15406053wampum

Search took 6 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.390458182.1
2DLD Change Limit1127161045.53020382.6
3Display Results1041040.0303466.7
 (SQL Overall)1786911045.95030032.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.