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

244 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
mallard1031027(None) 
mallards1138321mallards
ballad94315322balla_d
ballyard1445892ballyard
bollard103210502bollard
collard103712922collard
dullard936602dullard
galliard10125752galliard
halliard12125962halliard
halyard1476972halyard
lalland83810172lalland
malar76424442ma_lar_
malars85020682ma_lars
malled94626112mall_ed
mansard1049312mansard
manward1349092manward
mazard1838762ma_zard
mazzard1844462mazzard
milliard1147032milliard
paillard1146262paillard
pollard103511142pollard
aboard9312613_aboard
afeard1058263_afeard
aglare7312423_aglare
aland65526413_a_land
alar46340073_a_lar_
alarm76621423_a_larm
alary86123443_a_lary
allay85620393_alla_y
allayed11138063_allayed
allays94313743_allays
allied74217153_allied
allod64418383_all_od
allure63012943_allure
allured8299173_allured
altar55520643_altar_
altars64518153_altars
alular6311353_alular_
award97118043_a_ward
badland1147653badland
ballade104012563ballade
balladry1444213balladry
ballads104212913ballads
ballast9313993ballast
balled94926893ball_ed
baller83825203baller_
ballers94421013ballers
ballpark1643753ballpark
ballyards1544993ballyards
bastard103012423bastard
bayard124411663ba_yard
billiard1145873billiard
bollards11339153bollards
calcar10312753calcar_
calcars11312653calcars
calla74827073calla__
callan83619603calla_n
callans94518473callans
callant94121223callant
callas84526753calla_s
callboard1445663callboard
called94126733call_ed
caller85125483caller_
callers94221963callers
calvary1537183calvary
canard9314763ca_nard
cellar84514983cellar_
cellared11398793cellared
cellars93713693cellars
coalyard1444093coalyard
collar83816173collar_
collards113310193collards
collared113211143collared
collars93816573collars
dallied93713613dallied
dastard9279703dastard
dollar74110983dollar_
dollars83311023dollars
dullards1045493dullards
fallacy1536433fallacy
fallal93612693falla_l
fallals103310193fallals
fallboard1545053fallboard
faller94621233faller_
fallers103917993fallers
foulard11257283foulard
gabbard1336553gabbard
gallant83517113gallant
gallate83417123gallate
galled84622863gall_ed
gallery11468743gallery
galliards1194543galliards
gallied94115003gallied
garland948703garland
goalward1343493goalward
goliard936073goliard
haggard13377183haggard
halberd1336053halberd
hallah124115403halla_h
hallahs133912463hallahs
hallal94415563halla_l
halliards13104933halliards
hallmark1744213hallmark
halloaed121510153halloaed
halloed113314913halloed
halyards1576243halyards
haulyard1583223haulyard
hayward1736413hayward
hazard1938403ha_zard
holard10410573_holard
hollaed11359853hollaed
holland11349473holland
kailyard1643503kailyard
kaleyard1683573kaleyard
laggard10347623laggard
lallan63414173lalla_n
lallands9338563lallands
lallans74113533lallans
lalled74218753lall_ed
laniard868523laniard
lanyard1167293lanyard
lard56742003___lard
liard65418593__liard
lyard95113213__lyard
maar66025063ma__ar_
maars74621633ma__ars
macled116718113macl_ed
macular113011943macular_
maenad939413maena_d
mailed95326753mail_ed
mailer84724183mailer_
mailers94420333mailers
mainland1145213mainland
makar115614973ma_kar_
makars124612633ma_kars
malady1237863ma_lady
malaria9313693ma_laria
malarky1645433ma_larky
malate84624553ma_late
maleate94117543maleate
malfed12369763ma_lfed
malgre9299303ma_lgre
mall64639373mall___
mallee84525593mall_ee
mallees93315973mallees
mallei84414633mall_ei
mallet84433053mall_et
mallets93318493mallets
malleus92911313malleus
malling103623663malling
mallow114014743mall_ow
mallows123714323mallows
malls76233433mall__s
maltase938903maltase
malted94819863ma_lted
mammary1335993mammary
mansards1148013mansards
manuary1237773manuary
manwards1447613manwards
maraud938943ma_raud
marled95523163marl_ed
mascara1138023mascara
mauled94817823maul_ed
mauler84416713mauler_
maulers94213303maulers
maxillary2143443maxillary
maybird1543993maybird
mazards1937703ma_zards
mazzards1943943mazzards
medlar93010463medlar_
medlars10259443medlars
melled95023023mell_ed
midland1136613midland
miliary1249463miliary
millage103112753millage
millboard1444653millboard
milled94326173mill_ed
miller84625413miller_
millers93621343millers
milliards1246193milliards
milliare1039153milliare
milliary1346853milliary
milord999573m_ilord
mislaid1039303mislaid
molar75223093m_olar_
molars85517323m_olars
mollah11319453molla_h
mollahs12328283mollahs
mudlark1463913mudlark
mulla74317113mulla__
mullah113710733mulla_h
mullahs12388733mullahs
mullas84215933mulla_s
mulled94721553mull_ed
muller83820353muller_
mullers93217303mullers
mustard10359533mustard
mylar105311533m_ylar_
mylars114310443m_ylars
paillards1244983paillards
palled94625163pall_ed
pallid93915283pall_id
pallor8313673pallor_
pallors9314363pallors
palmar104113463palmar_
palmary14338553palmary
pillar8314023pillar_
pillared11228093pillared
pillars9313493pillars
placard1236783placard
pollards11299523pollards
poulard10299733poulard
rallied83514083rallied
saggard10358953saggard
salad65321833sa_la_d
salary9515213sa_lary
sallied83316953sallied
smallage1145183smallage
smaller93410333smaller_
tabard9313333ta_bard
talar56225383ta_lar_
talars66021683ta_lars
tallage82712073tallage
tallaged10257923tallaged
taller63721963taller_
tallied83314753tallied
tankard1267263tankard
tanyard1167183tanyard
vallate103016563vallate
valvar12388653valvar_
vanward1456943vanward
vaward13498723va_ward
walla85321033walla__
wallaby1535073wallaby
wallah124011993walla_h
wallahs13409473wallahs
wallaroo1144613wallaroo
wallas95719393walla_s
wallboard1545023wallboard
walled104021293wall_ed
warlord1136293warlord
waylaid1445093waylaid
wayward1736053wayward
willyard1543963willyard

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.1401276364.3
2DLD Change Limit1340272446.23621492.5
3Display Results2442440.0932623.7
 (SQL Overall)1786912446.46927622.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.