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

120 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
palliums123670(None) 
alliums957971_alliums
galliums1145961galliums
pallium1149011pallium_
allium8311242_allium_
calciums1446162calciums
gallium1037942gallium_
kaliums1336602ka_liums
pablums1345122pabl_ums
palladiums1543312palladiums
phallisms1645072phallisms
psylliums1642192psylliums
thalliums1443252thalliums
alarums9408923_alarums
albums10198273_a_lbums
algums9208043_a_lgums
allies63827673_alli_es
alluviums1443083_alluviums
alums75720603_a_l_ums
atriums939043_atriums
baalisms1238033baalisms
ballies93725743balli_es
bariums1139143ba_riums
bdelliums1442053bdelliums
cadmiums1544403cadmiums
caesiums1245533caesiums
caladiums1444633caladiums
calcium1368593calcium_
callings113613833callings
callous93516603callou_s
callus85317073call_u_s
cambiums1644933cambiums
dalliers93610613dalliers
dallies84023193dalli_es
fallouts1137883fallouts
foliums1237173_foliums
galliass935423galliass
gallicas1136933gallicas
gallies84122713galli_es
galliots9228683galliots
gallnuts943923gallnuts
gallous82813953gallou_s
gallus74313203gall_u_s
hafniums1643103hafniums
hahniums1643343hahniums
hassiums1344273hassiums
heliums12188303_heliums
holmiums1544153holmiums
kalium1239473ka_lium_
malleus92911313malleu_s
mallings113413093mallings
natriums1046293natriums
pablum1237503pabl_um_
pabulums1443003pabulums
pailfuls1343843pailfuls
palais8420423palai__s
palings103915823pa_lings
palladium1444433palladium_
pallets93919303pall_ets
pallia83015593palli__a
pallial92911253palli_al
palliasse1173023palliasse
palliate10311893palliate
palliates11311033palliates
pallid93915283palli__d
pallidly1444063pallidly
pallier94417163palli_er
palliest102814633palliest
palling104024483palli_ng
pallors9314363pall_ors
palls74332563pall___s
palmfuls1543473palmfuls
palmists12268813palmists
palms94921753pa_l__ms
palpus104210283pa_lpu_s
palsies94420273palsi_es
paludisms1444013paludisms
panicums1444743panicums
pantoums1236713pantoums
papadums1573853papadums
papisms13238543pa_pisms
parlours1036153parlours
parlous9414293parlou_s
paulins9312613pauli_ns
paynims1434973payni_ms
peplums13145503pepl_ums
phallism1545713phallism_
phallists1445723phallists
phallus1236063phall_u_s
pillions101610923pillions
platinums1343963platinums
plenums1136533p_lenums
plums94619953p__l_ums
podiums12227633p_odiums
pollices12410753pollices
pollists10910823pollists
poloniums1346053poloniums
prelims1139823preli_ms
premiums1437533premiums
protiums1238553protiums
psyllium1543033psyllium_
pullouts1045223pullouts
pullups1134233pull_ups
radiums10299313ra_diums
ralliers84010833ralliers
rallies73823343ralli_es
salliers83613343salliers
sallies73227813salli_es
talcums1135513ta_lcums
talliers83711373talliers
tallies73624603talli_es
tallis63319963talli__s
tallises82713263tallises
talliths11377433talliths
tallits73215993talli_ts
thallium1344433thallium_
thuliums1343553thuliums
trilliums1144333trilliums
vellums1235293vell_ums
wallies103320743walli_es

Search took 10 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.423422437.4
2DLD Change Limit1461621208.51617163.2
3Display Results1201200.0462608.7
 (SQL Overall)1786911208.98519887.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.