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

205 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
pablum123750(None) 
pablums1345121pablums
pabulum1344471pabulum
album92312652_album
alum65227612_a_lum
labium10410242labium
labrum1057422labrum
pabulums1443002pabulums
pallium1149012pallium
palm85331362pa_l_m
peplum12156822peplum
phylum1655152phylum
plum85122102p__lum
abeam9316533_abeam
ablaut8313263_ablaut
able66340533_abl_e
abled86926833_abled
abler75624313_abler
ables75935543_ables
abloom1039783_abloom
ablush1147223_ablush
ably99725133_abl_y
abohm1247973_abohm
about75229083_about
abut66834953_ab_ut
abysm12598143_abysm
albums10198273_albums
algum82711763_algum
allium8311243_allium
alums75720603_a_lums
amylum1344693amylum
arum66129033_a_rum
asylum1144893asylum
aurum7614963_aurum
baalim1038473baalim
babu85829233bab_u_
babul96317713bab_ul
babuls105413643babuls
babus95620333bab_us
baculum1345703baculum
balm85534203ba_l_m
barium10313513barium
blam86131703__blam
blub85324873__blub
blue65328463__blue
blume95619893__blume
blur66020533__blur
bum75342693__b_um
cable95329913cabl_e
cabled114819873cabled
cabler104519173cabler
cables104527553cables
cablet104429463cablet
caecum1238183caecum
callus85317073callus
calm85032363ca_l_m
cambium1537323cambium
dadgum1134583dadgum
datum8310633da_tum
emblem1237583emblem
erbium1038083erbium
fable105824753fabl_e
fabled124216383fabled
fabler116115813fabler
fables114921673fables
fanum10313443fa_num
filum105015433_filum
gable85325523gabl_e
gabled105518453gabled
gables94222333gables
gallium1037943gallium
gallus74313203gallus
gaum75726423ga__um
glum75825103__glum
habu97325483hab_u_
habus106317143hab_us
hallux1637363hallux
halm95834973ha_l_m
haulm104415413haul_m
hilum105514603_hilum
kalam11315113ka_lam
kalium1239473kalium
labarum1166013labarum
labellum1274273labellum
labour84210933labour
labrums1175853labrums
larum74317973la_rum
lum55542933___lum
magnum1136733magnum
malm85129983ma_l_m
mamluk1434743mamluk
oakum1177313oa_kum
pabular11259473pabular
padauk1335643padauk
padle84522343padl_e
padles95221123padles
padouk1336683padouk
paella8410913paella
pail66141833pail__
pailful1236103pailful
pails75833063pail_s
pal56761673pa_l__
pale66055013pa_l_e
palea75028663pa_lea
paled85538723pa_led
paler75436933pa_ler
pales75753803pa_les
palet74650803pa_let
pall65039343pa_l_l
palled94625163palled
pallet84232653pallet
pallia83015593pallia
pallid93915283pallid
palliums1236703palliums
pallor8313673pallor
palls74332563pa_lls
pally105727123pa_lly
palms94921753pa_lms
palmy126016733pa_lmy
palp85828573pa_l_p
palpi95414553pa_lpi
palps94719563pa_lps
palpus104210283palpus
pals66951353pa_l_s
palsy105417463pa_lsy
paly95835533pa_l_y
pam77858393pa___m
panful1179743panful
panicum1346393panicum
pantoum1138703pantoum
papadum1475233papadum
papism122211513papism
pappus9408373pappus
papula103011113papula
papule102212133papule
pareu74928743pareu_
pareus85420743pareus
parlay113713993parlay
parle75836163parl_e
parled94626293parled
parles86334403parles
parley116718363parley
parlor8312673parlor
parlour937263parlour
parlous9414293parlous
parous84024163parous
passim10410283passim
passus83610293passus
patly105020583patl_y
paulin8312983paulin
pawl95123263pawl__
pawls105617663pawl_s
paynim1337363paynim
payout11714653payout
peplums13145503peplums
peplus10138343peplus
phallus1236063phallus
pileum10399513pileum
pilus75921063p_ilus
plenum1039503plenum
plug74915993p__lug
plumb114514073p__lumb
plume94819463p__lume
plump115315263p__lump
plums94619953p__lums
plumy124213233p__lumy
plus66324833p__lus
podium112911913podium
poilu72316003poilu_
poilus82210573poilus
possum1057953possum
prelim10311423prelim
problem1335983problem
psalm949273psal_m
public12238143public
pullup1045893pullup
radium93513293radium
sable74732163sabl_e
sables85026693sables
sacrum103910143sacrum
sagum8512873sa_gum
sebum93814553seb_um
siglum936563siglum
slum65430513__slum
solum74717613_solum
subgum1136133subgum
tabla73318363tabl_a
tablas83716163tablas
table75429603tabl_e
tabled94020043tabled
tables84524893tables
tablet84227643tablet
tabour84011323tabour
tabu66328493tab_u_
tabuli839363tabuli
tabun75914373tab_un
tabus74820923tab_us
talcum1036953talcum
taluk94812873ta_luk
talus55423263ta_lus
vacuum1334833vacuum
value85719093va_lue
vellum1136773vellum
velum10713383_velum
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 Limit1127162054.84323274.0
3Display Results2052050.0633254.0
 (SQL Overall)1786912055.29633740.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.