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

248 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
uplands103694(None) 
upland938861upland_
alands75418372_alands
elands74914772_elands
glands85314402_glands
inlands838782inlands
islands837322islands
lands65426902__lands
outlands988562outlands
plaids94312442_plaids
planes85028082_planes
planks124116752_planks
plans75731272_plan_s
plants84921802_plants
relands85214882relands
solands84412342solands
sunlands936382sunlands
uhlans937572uhlan_s
ulans54921302u_lan_s
unhands1137772unhands
upbinds12234812upbinds
upends9438762up_ends
uplander1145532uplander
uplanders1234852uplanders
uplinks13345612uplinks
uploads10266502uploads
upsends10265292upsends
upstands1144092upstands
upwards13135962upwards
upwinds13224222upwinds
aland65526413_aland_
alans55636173_alan_s
alants67722023_alants
ands57833613___ands
appends1236393appends
applauds13103283applauds
badlands1236673badlands
bands85233423__bands
belauds1036643belauds
biplanes1238573biplanes
bland85320453_bland_
blanks124112893_blanks
blends96012883_blends
blinds95111613_blinds
blonds95213343_blonds
brands95118943_brands
bushlands1543403bushlands
calando1037383calando
calends1039523calends
clads85722733_cla_ds
clangs95113613_clangs
clanks124615183_clanks
clans75031013_clan_s
croplands1445373croplands
demands114311413demands
deplanes11311213deplanes
desands94810163desands
dullards1045493dullards
dunelands1142773dunelands
eland65820393_eland_
elans55527753_elan_s
emplanes1239503emplanes
enplanes1039483enplanes
errands847603errands
euploids1157243euploids
expands17195733expands
explants1737023explants
fenlands1245183fenlands
flanes94522423_flanes
flanks133913403_flanks
flans85327973_flan_s
garlands1038323garlands
gelants82611443gelants
glads75620613_gla_ds
gland75217713_gland_
glandes95413833_glandes
glans65125833_glan_s
grands84218243_grands
hands95327383__hands
holards1148433holards
hollands12247273hollands
husbands1444763husbands
implants1237883implants
inland7310313inland_
island738533island_
kalends1235683kalends
lads56549133__la_ds
lallands9338573lallands
land56337313__land_
lanes54946793__lanes
lards65331863__lards
lauds65618483__lauds
lends65326253__lends
ligands9438983ligands
llanos6108333_llanos
lowlands1244373lowlands
midlands1245543midlands
norlands936443norlands
operands1146813operands
outland81212343outland_
outplans10259533outplan_s
pads76742953_p_a_ds
panda85022613_p_anda
pandas95521963_p_andas
pandy115021173_p_andy
panes76148693_p_anes
pangs84628663_p_angs
pans65855733_p_an_s
pants76536923_p_ants
pards85634333_p_ards
peans75437643_pean_s
pends85527193_p_ends
pianos84315933_pianos
pians75126963_pian_s
places104323703_places
placks144414153_placks
plafonds1443273_plafonds
plages94520153_plages
plaid85118303_plaid_
plains85019593_plains
plaints94012053_plaints
plaits83816473_plaits
plan65833943_plan__
planar84212713_planar
planch133711443_planch
plane74929143_plan_e
planed94420913_planed
planer84122653_planer
planers94517943_planers
planet84228353_planet
planets93914083_planets
planish12412053_planish
plank115221143_plan_k
plant75437113_plan_t
plasms103711333_plasms
plates85432243_plates
plats75531373_pla_ts
platys11459853_platys
playas114612283_playas
plays106320773_pla_ys
plazas17409913_plazas
pleads94613953_pleads
plinks124913263_plinks
plods85719293_pl_ods
plonks124210423_plonks
plunks124711163_plunks
poinds93511143_poinds
ponds85323403_p_onds
pounds93714383_pounds
prangs94816233_prangs
pranks124814723_pranks
pulings103511323pulings
puranas9712643puranas
rands65930453__rands
reland75920433reland_
relends84013253relends
remands104914883remands
replans92814943replan_s
replants102811243replants
ribands10208393ribands
rimlands1145243rimlands
robands10219863robands
salads75316963sala_ds
sands65228583__sands
silanes72517163silanes
slangs75615343_slangs
slants64819083_slants
soland75115043soland_
solanos74412853solanos
solans64122493solan_s
spanks124514123sp_anks
spans74528733sp_an_s
speans85417143spean_s
spends94714473sp_ends
splakes1349673splakes
splats84817303spla_ts
splays114910873spla_ys
splents93912133splents
splines94718893splines
splints94511743splints
sprangs104610053sprangs
stands75118053_stands
strands83711953strands
summands1344713summands
sunland837473sunland_
supplants1344873supplants
tolanes74216313tolanes
tolans64319273tolan_s
trolands936423trolands
uhlan849113uhlan__
ulamas8910453u_lamas
ulan46527393u_lan__
ullages838953ullages
ulnad65611453u_lnad_
ulnas55716533u_l_nas
ulpan7310123ulpan__
ulpanim1143993ulpanim
umlauts943193umlauts
unbans81912623unban_s
unbends10236993unbends
unbinds10267353unbinds
unhand10410383unhand_
unhandy1445513unhandy
unhangs1136203unhangs
unlaces92513623unlaces
unlade72714153unla_de
unlades82612833unlades
unlaid7311753unlaid_
unlays93810493unla_ys
unleads8228623unleads
unlinks11307403unlinks
unloads8278523unloads
unmans82211993unman_s
unplaits1044813unplaits
unwinds11286733unwinds
upas68322383up_a__s
upases84112903up_ases
upbind11246313upbind_
upbraids1343553upbraids
upcasts11185643upcasts
updarts1034203updarts
updates10329793updates
upend85011043up_end_
upflings1433733upflings
upfolds13133753upfolds
upgazes1933573upgazes
upgirds11103073upgirds
uphoards1443763uphoards
upholds13135243upholds
upleaps1185233upleaps
uplifts12424773uplifts
uplink12388713uplin_k
upload9257783upload_
uppings12257123uppings
uprates93814863uprates
upsend9356883upsend_
upstand1045343upstand_
uptakes1336593uptakes
uptalks1333723uptalks
uptrends1142833uptrends
upwafts1541943upwafts
upward12147163upward_
upwind12255823upwind_
viands1047813_viands
wands96425483__wands
wetlands1244763wetlands
xylans1635883xylan_s
yulans958673yulan_s

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.406440125.6
2DLD Change Limit1340272485.96622465.1
3Display Results2482480.0803100.0
 (SQL Overall)1786912486.45227695.4
 
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.