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

195 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
holland1134947(None) 
hollaed11359851hollaed
hollands12247271hollands
bollard103210502bollard
collard103712922collard
holard10410572ho_lard
holla84918492holla__
hollaing12167102hollaing
hollas94616902holla_s
holloaed12157392holloaed
holloed113812752holloed
homeland1446232homeland
lalland83810182lalland
lowland1134692lowland
norland837162norland
pollard103511142pollard
soland75115042so_land
aland65526413__aland
badland1147653badland
ballad94315323balla_d
bland85320453__bland
bollards11339153bollards
bolled94722653boll_ed
bolling103820883bolling
callan83619603callan_
callans94518473callans
callant94121223callant
cholla113911023cholla__
chollas123811353cholla_s
colead94114643colea_d
collage102813763collage
collaged12279973collaged
collar83816173colla_r
collards113310193collards
collared113211143collared
collars93816573collars
collate92919683collate
collated113615063collated
collied103316673collied
collins93419833collins
colloid10312883colloid
command14399213command
coolant9316463coolant
cowhand1665933cowhand
cropland1346303cropland
dockland1643713dockland
dollar74110983dolla_r
dollars83311023dollars
dolled83518073doll_ed
dollied93811143dollied
dolling93817373dolling
dolman95312403dolman_
dolmans10479683dolmans
downland1364533downland
dryland1254303dryland
dullard936603dullard
eland65820393__eland
eolian6312593eolian_
fenland1135693fenland
filmland1443153filmland
foreland1239013foreland
foulard11257283foulard
gallant83517113gallant
garland948703garland
gellant83214053gellant
gland75217713__gland
goliard936073goliard
gormand1157453gormand
hallah124115403halla_h
hallahs133912463hallahs
hallal94415563halla_l
halliard12125963halliard
halloaed121510153halloaed
halloed113314913halloed
halyard1476973halyard
hand86833713h___and
hatband1346823hatband
headland1345613headland
helled104024703hell_ed
helling114623223helling
helloed113512423helloed
highland16114533highland
hilled104022223hill_ed
hilling113821773hilling
hilloaed12136923hilloaed
hilloed113211293hilloed
hoard94918313ho__ard
hodad10311353ho_da_d
hogan97817703ho_gan_
hogans105914313ho_gans
hogmane1336343hogmane
holards1148433ho_lards
hold86235063ho_l__d
holdall1145473holdall
holden104113953holden_
holding123514283holding
holed95634133ho_l_ed
holing104025073ho_ling
holked144913663ho_lked
holking153512313holking
holler93520613holl_er
hollered1237603hollered
hollers103818233hollers
hollies103420813hollies
hollo84822163holl__o
holloa94914823holl_oa
holloaing1385803holloaing
holloas103814943holloas
holloes103818193holloes
holloing12148823holloing
holloo94415253holl_oo
hollooed12146493hollooed
holloos104013583holloos
hollos95320633holl_os
hollow124212663holl_ow
hollowed15157023hollowed
hollows134412333hollows
holly114824433holl__y
holpen11299413holpen_
homelands1545443homelands
honan85319773ho_nan_
honans94814503ho_nans
honorand1246333honorand
hotline10712353hotline
hotlink1476763hotlink
hound95016483ho__und
howled134014973howl_ed
howling143413163howling
hulled103920013hull_ed
hulling113619013hulling
hulloaed12105803hulloaed
hulloed11369793hulloed
husband1345653husband
inland7310313_inland
island738533_island
jollied15349273jollied
lallan63414173lallan_
lallands9338573lallands
lallans74113533lallans
land56337313___land
llano5910603__llano
lolled74315823loll_ed
lolling83415783lolling
lowlands1244373lowlands
mallard10310273mallard
midland1136613midland
mollah11319453molla_h
mollahs12328283mollahs
moorland1144683moorland
norlands936443norlands
olla44821173_olla__
ollas54218283_olla_s
outland81212343outland
plowland1442743plowland
poblano1145093poblano
polkaed1435323polkaed
pollack1567333pollack
pollards11299523pollards
polled94022003poll_ed
pollen83416453pollen_
pollened1157783pollened
pollens93713303pollens
polling102920383polling
poulard10299733poulard
reland75920433_reland
rimland1035663rimland
roband92310723ro_band
rolled74220243roll_ed
rolling83620413rolling
shetland1244633shetland
snowland1243833snowland
solan55328153so_lan_
solands84412343so_lands
solano65314183so_lano
solans64122493so_lans
soldan73511853soldan_
soldans83210403soldans
sunland837473sunland
thousand1242823thousand
tolan55124013to_lan_
tolane64316583to_lane
tolans64319273to_lans
tollage82610163tollage
tolled73819033toll_ed
tolling83418563tolling
tollman935863tollman_
troland837543troland
upland938863_upland
volant9316323vo_lant
volcano1244613volcano
volplane1344313volplane
volplaned1542733volplaned
wetland1135353wetland
wildland1353843wildland
woodland1344603woodland

Search took 8 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 Limit1340271956.67320085.0
3Display Results1951950.0633095.2
 (SQL Overall)1786911957.12625075.9
 
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.