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 “vacuums” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

81 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
vacuums144340(None) 
vacuum1334831vacuum_
baculums1443722baculums
sacrums11388042sacrums
vacuous1237022vacuous
vacuumed1641592vacuumed
vasculums1642142vasculums
acutes83917723_acutes
albums10198273_albums
algums9208043_algums
alums75720603_a_lums
arums75517833_a_rums
aurums849383_aurums
backups1736173backups
baculum1345703baculum_
bariums1139143bariums
cactus104912233cactu_s
calciums1446163calciums
caucus1039613caucu_s
chums125015833__chums
culms95314193__culms
datums936353da_tums
dictums1235553dictums
evacuees1382483evacuees
fanums1137263fa_nums
gaums86217073ga__ums
haulms11558503ha_ulms
kaliums1336603kaliums
labrums1175853labrums
lactams1136953lactams
lacunas9138173lacunas
lacunes9159623lacunes
larums83610533la_rums
locums10478303loc_ums
lyceums1442403lyceums
maculas113114023maculas
macules114015133macules
magnums1234683magnums
oakums1264153oa_kums
pablums1345123pablums
pabulums1443003pabulums
racisms112310813racisms
radiums10299313radiums
rectums11338523rectums
sacbuts1166473sacbuts
sachems14348903sachems
sacques18106863sacques
sacrum103910143sacrum_
sanctums1244013sanctums
scrums104614253_scrums
scums95017423_sc_ums
talcums1135513talcums
tectums11306423tectums
vacates12312833vacates
vacs96226203vac___s
vacua10510463vac_u_a
vacuity1545763vacuity
vacuole1245373vacuole
vacuoles1345013vacuoles
vacuuming1741903vacuuming
vagus96713813va_gu_s
valgus1047103valgu_s
valours10248743valours
valuers10328943valuers
values94314943va_lues
valutas1036533valutas
vapours12277463vapours
varooms1248883varooms
varus85921183va_ru_s
varuses10310623varuses
vasculum1542983vasculum_
vatfuls1384853vatfuls
vatus86114643va_tu_s
vaults94511673va_ults
vaunts95212623va_unts
vaus75928923va__u_s
vellums1235293vellums
victims1436003victims
vicunas1285613vicunas
vinculums1642073vinculums
wampums16314213wampums

Search took 7 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.390458182.1
2DLD Change Limit134027816.51620568.9
3Display Results81810.0332454.5
 (SQL Overall)178691816.93925751.7
 
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.