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

228 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
garland94870(None) 
garlands1038321garlands
aland65526412_a_land
badland1147652badland
engarland1142122engarland
farmland1454232farmland
gallant83517112gallant
gangland1145192gangland
gardant9314462gardant
garlanded1244692garlanded
gland75217712g__land
gormand1157452gormand
grand75122692g_r_and
lalland83810182lalland
norland837162norland
parkland1545372parkland
parlando1145412parlando
yardland1343762yardland
aground9216183aground
alan46844083_a_lan_
alands75418373_a_lands
alane56135613_a_lane
alang66023513_a_lang
alans55636173_a_lans
alant55742293_a_lant
arcana8912583_arcana
arcane81216743_arcane
armband1265983_armband
around72712413_around
arrant6623253_arrant
aslant6317753_aslant
backland1748103backland
badlands1236673badlands
ballad94315323balla_d
barehand1446153barehand
barmaid1238203barmaid
barman103519703barman_
bartend1038753bartend
bland85320453__bland
brand85124493_br_and
calando1037383ca_lando
callan83619603callan_
callans94518473callans
callant94121223callant
carlin84421823carlin_
carline93923613carline
carling103727063carling
carlins93921923carlins
carload1039783carload
carman103920743carman_
darling93418363darling
dryland1254303dryland
earlap837183earla_p
earlaps936393earlaps
eland65820393__eland
engarlands1261673engarlands
errand758793_errand
fahlband1742643fahlband
fairyland1642423fairyland
farad95720673far_a_d
farmhand1743563farmhand
farmlands1543863farmlands
fenland1135693fenland
flatland1264963flatland
foreland1239013foreland
gabbard1336553gabbard
gabled105518453gabl_ed
gabling113514543gabling
gagman103811243gagman_
gala55635163ga_la__
galago838913ga_lago
galah95917643ga_la_h
galahs105512683ga_lahs
galanga936023ga_langa
galas65731643ga_la_s
galax135314463ga_la_x
galaxy17476313ga_laxy
galena74911093ga_lena
gallanted1145903gallanted
gallants93310373gallants
gallate83417133gallate
galled84622863ga_lled
galliard10125753galliard
gallied94115003gallied
galling93921963galling
gallon73715813gallon_
gallons83015953gallons
gamelan10106643gamelan_
gamelans11115843gamelans
ganglands1244453ganglands
gaoled84814503gaol_ed
gaoling93314653gaoling
garage8314513gar_age
garaged1039253garaged
garbage1138053garbage
garbagy1444243garbagy
garbanzo2042583garbanzo
garbed104815663gar_bed
garbing113613273garbing
garbled114512803garbled
garbling12249453garbling
garboard1247243garboard
garcon92912483garcon_
garcons102411643garcons
garda7316763garda__
gardai839663garda_i
garden84215083garden_
gardened1137003gardened
gardens93312093gardens
garganey1344883garganey
gargled104210673gargled
gargling11239203gargling
garlanding1344433garlanding
garlic9310043garl_ic
garlics1038013garlics
garment10315233garment
garni6315703gar__ni
garoted9710133garoted
garred85217413gar_red
garring93116713garring
garron73113493garron_
garrons82713463garrons
gasman92911743gasman_
gelant72821673g_elant
gellant83214053gellant
german9611983german_
germane1049663germane
germans1079473germans
gerund836163ger_und
glad65624013g__la_d
glands85314403g__lands
glans65125833g__lans
gnarled9287723gnarl_ed
gnarling10217603gnarling
gormands1266563gormands
gourmand1243263gourmand
grad66829863g_r_a_d
graduand1143893graduand
gran56335013g_r_an_
grana65722093g_r_ana
grands84218243g_r_ands
grans64832543g_r_ans
grant64840023g_r_ant
grassland1153473grassland
grind75917563g_r_ind
groan65618423g_roan_
groaned9259973g_roaned
groans74815063g_roans
ground82310273g_round
guarana886303guar_ana
guarani8106273guar_ani
guardant1046443guardant
gurnard944773gurnard
hairband1444573hairband
hariana10310243hariana
hatband1346823hatband
headland1345613headland
heartland1343653heartland
holland11349473holland
inland7310313_inland
island738533_island
lallan63414173lallan_
lallands9338573lallands
lallans74113533lallans
land56337313___land
largando1043803largando
lowland1134693lowland
mainland1145213mainland
mallard10310273mallard
maraud938943mar_aud
marchland1743833marchland
marled95523163marl_ed
marlin84220903marlin_
marline93320953marline
marling103322763marling
marlins93420473marlins
marrano939423marrano
marshland1543353marshland
midland1136613midland
moorland1144683moorland
norlands936443norlands
outland81212343outland
overland122312003overland
parang93715513par_ang
parian83223963parian_
parians93519733parians
parklands1654713parklands
parlance1248723parlance
parlante1039693parlante
parlay113713993parla_y
parlayed1435823parlayed
parlays123910453parlays
parled94626293parl_ed
parling103823763parling
partan83820563partan_
partans94418283partans
playland1444573playland
raglan73711503raglan_
raglans82410133raglans
rand55839573__r_and
reland75920433_reland
rimland1035663rimland
salad65321833sa_la_d
saraband1146193saraband
saran53730303sar_an_
sarans64224433sar_ans
sardana838643sardana
scabland1344293scabland
soland75115043_soland
strand74514823str_and
sunland837473sunland
tarpan82814293tarpan_
tarpans92513533tarpans
tartan64217513tartan_
tartana73010193tartana
tartans72615823tartans
tarzan152910753tarzan_
tarzans16329923tarzans
troland837543troland
upland938863_upland
variant10316803variant
warlord1136293warlord
warplane1345983warplane
warrant10614243warrant
waylaid1445093waylaid
wetland1135353wetland
yardlands1443583yardlands
yardwand1642743yardwand

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 Limit1340272286.82619634.8
3Display Results2282280.0932451.6
 (SQL Overall)1786912287.30924448.1
 
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.