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

61 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
sanctums124401(None) 
sanctum1145291sanctum_
sacrums11388042sa_crums
santims9312602san_tims
santurs7310762san_turs
antrums969173_antrums
bantams1149063ban_tams
cactus104912233ca_ctu_s
calciums1446163calciums
cantus85117763can_tu_s
centums11398783cen_tums
datums936353da__tums
dictums1235553_dictums
fantoms12189153fan_toms
fanums1137263fan__ums
franciums1644413franciums
lactams1136953la_ctams
manitus9310923manitu_s
mantuas93410993man_tuas
panicums1444743panicums
pantoums1236713pantoums
rancours1076713rancours
rectums11338523_rectums
sacbuts1166473sa_cbuts
sachems14348903sa_chems
sacques18106863sa_cques
sacrum103910143sa_crum_
sancta839833sanct__a
sanctify1644493sanctify
sanction1049533sanction
sanctions1138873sanctions
sanctity1345593sanctity
sanctuary1442183sanctuary
sandburs11105623sandburs
sanious7514103saniou_s
sanities81219773sanities
sannups934463san_nups
santimi938793san_timi
santimu938563san_timu
santirs7312963san_tirs
santols73513323san_tols
santos64421833san_t_os
santours837183santours
santur6311273san_tu_r
sarcasms1244983sarcasms
sarcous9312933sarcou_s
scandiums1443983scandiums
scrotums1243973scrotums
scrums104614253s__crums
scums95017423s__c_ums
septums1135743s_eptums
spectrums1543173spectrums
stannums1043803stan_nums
stickums1643943stickums
stratums10266803stratums
stums75320083s___tums
syncoms1435943sync_oms
talcums1135513talc_ums
tantrums1045113tantrums
tectums11306423_tectums
vacuums1443403va_cuums

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 Filter1786911461620.450397091.1
2DLD Change Limit146162618.34617512.8
3Display Results61610.0302033.3
 (SQL Overall)178691618.82620246.0
 
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.