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

458 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
remands10491488(None) 
demands114311411demands
relands85214881relands
remand95618961remand_
remans84823001reman_s
remends105013031remends
reminds104614791reminds
demand104314252demand_
desands94810162desands
elands74914772_elands
emends95711432_emends
errands847582errands
lemans85316392leman_s
rands65930452r__ands
readds84111642re_adds
reads64835272re_a_ds
rebinds104511872rebinds
recanes93222262recanes
recants93217092recants
redans75421022redan_s
redemands1344632redemands
refinds114512122refinds
refunds11448622refunds
regards94112562regards
rehangs1137562rehangs
reland75920432reland_
relends84013252relends
remade94316982rema_de
remails94714562remails
remains94117892remains
remakes134116172remakes
reman75730152reman__
remanded123011322remanded
remaps105012872rema_ps
remarks13329982remarks
remates93827102remates
remend95216552remend_
remind94819792remind_
remints95117292remints
remnants1036842remnants
remolds10299702remolds
rends65129952re__nds
repand95316062repand_
resends83513712resends
retards85015002retards
rewards114813992rewards
rewinds114810482rewinds
ribands10208392ribands
rimlands1145242rimlands
robands10219852robands
romanos94311472romanos
romans84620242roman_s
alands75418373_alands
almonds10127953almonds
amends94713283_amends
ands57833613___ands
armbands1355143armbands
atmans84413963atman_s
bands85233423__bands
barehands1545253barehands
beads85429503be_a_ds
beanos85516513be_anos
beans75734693be_an_s
beards94116673be_ards
behinds1335283behinds
belauds1036643belauds
bemas96424283bema__s
bemeans1148733bemean_s
bemoans1138253bemoan_s
bends85628973be__nds
beyonds1335063beyonds
bezants1877343bezants
brands95118943_brands
breads95419203bre_a_ds
brigands1245623brigands
cements112714223cements
cetanes9315133cetanes
commands15318813commands
cremains1238673cremains
cremates124215983cremates
creminis12208253creminis
damans94715983daman_s
deads75726913de_a_ds
deans66131393de_an_s
decanes103118913decanes
decants103514443decants
dedans85915073dedan_s
defangs1235363defangs
defends12358773defends
defunds12376753defunds
demanded13348513demanded
demander12238723demander
demanders13247573demanders
demarks14339233demarks
demasts1089223demasts
demeans1039713demean_s
dements103016623dements
demons94917723demon_s
deodands1144603deodands
depends11348993depends
desand84812633desand_
desmans1039003desman_s
dewans105215143dewan_s
dreads84115023dre_a_ds
dreamlands1441853dreamlands
dromonds1244613dromonds
egads74610923_ega_ds
eland65820393_eland_
elans55527753_elan_s
emails84412333_emails
embanks15295703_embanks
embeds11377893_embeds
emend86214893_emend_
emyds1144923_em_yds
ends56528523_e__nds
ermines9416663ermines
errand758793errand_
errants7410623errants
expands17195733expands
females12310663females
fends96324973fe__nds
fenlands1245183fenlands
forehands1656743forehands
forelands1347173forelands
gelants82611443gelants
germans1079463german_s
gerunds935183gerunds
glands85314403_glands
gormands1266563gormands
grands84218243_grands
hands95327383__hands
heads95127113he_a_ds
hemins113417563hemin_s
heralds1137703heralds
hetmans12187593hetman_s
hexads17468193hexa_ds
hexanes17319463hexanes
humans112312433human_s
inlands838783inlands
islands837323islands
jeans126022113je_an_s
jehads1735833jeha_ds
lands65426903__lands
leads66028493le_a_ds
leans55536253le_an_s
legends936073legends
leman75622603leman__
lemons84415053lemon_s
lends65326253le__nds
levants1037723levants
ligands9438983ligands
limans84816303liman_s
mads76845363__ma_ds
maids86327133__maids
manas76240423__manas
manes76648953__manes
manos74933613__manos
mans66354533__man_s
manus75924923__manus
mauds85519273__mauds
maunds9519653__maunds
meads85425323me_a_ds
means75831223me_an_s
menads95514383mena_ds
mends84927693__mends
mermaids1355733mermaids
minds85427123__minds
nemas75321573nema__s
nomads94711603noma_ds
operands1146813operands
oreads73915773ore_a_ds
oreganos945553oreganos
osmunds1042883osmunds
peans75437643pe_an_s
pecans101515833pecan_s
pedants10310113pedants
pekans121710553pekan_s
penangs10268373penangs
pends85527193pe__nds
petards104311153petards
prebends13347883prebends
prebinds13357733prebinds
prefunds1454693prefunds
premade12311443prema_de
preman104117453preman__
premeds12389583prem_eds
premolds1345843premolds
pretends11299113pretends
probands13228383probands
rads56046603r__a_ds
raids65827513r__aids
ramada9310183rama_da
ramadas1039303ramadas
ramonas9311093ramonas
ramrods1036583ramrods
rand55839563r__and_
randy95022083r__andy
ranids75118703r__anids
ranis55235833r__anis
ranks95225733r__anks
rants55935343r__ants
ratans63819373ratan_s
reacts83616603re_acts
read55942533re_a_d_
readd74617133re_a_dd
ready94821503re_a_dy
reales64934123re_ales
realms84913493re_alms
reals55038653re_a_ls
reamed94326123reamed_
reamers94221083reamers
reams75729623re_a_ms
reaps75626193re_a_ps
rearms85114653re_arms
rears54739653re_a_rs
reatas64021013re_atas
reaves94127573re_aves
rebaits9312573rebaits
rebars84019823reba_rs
rebates95123173rebates
rebatos92913093rebatos
rebids94015523re_bids
rebind94416923rebind_
reblends1135293reblends
reboards1138773reboards
rebounds1156023rebounds
recalls92613613recalls
recane83022873recan_e
recaned102817203recaned
recant83228683recan_t
recaps103615733reca_ps
recasts93413533recasts
reclads1049993reclads
recons84922993recon_s
records105213923records
redacts10510943redacts
redan66125013redan__
redates83423863redates
redbuds11144283redbuds
redds74617833re__dds
redemand1245923redemand_
redons75222183redon_s
redounds1055963redounds
reds56042863re___ds
reearns749103reearns
reeds65430903re__eds
refaces123216743refaces
refalls103312243refalls
refeeds11368973refeeds
refind104717073refind_
refines105426343refines
refolds11298953refolds
refounds1255733refounds
refund104810303refund_
regains84316583regains
regales83520793regales
regard85215773regard_
regents83416543regents
regilds996673regilds
reginas85614063reginas
regrants9310013regrants
regrinds1035533regrinds
rehabs1139023reha_bs
rehandle1246173rehandle
rehandles1345593rehandles
rehang1039823rehan_g
reigns74811753reign_s
reimages1138373reimages
reinks105012153re_inks
reins56234563re_in_s
relaces93420883relaces
relaid75518443relaid_
relanded102410463relanded
relates73731423relates
relaxes143215323relaxes
relays94316753rela_ys
relend76116453relend_
relents74018503relents
relines75331323relines
relinks114510223relinks
reloads8911313reloads
reloans7313133reloan_s
remail85017123rema_il
remain85919863rema_in
remainder1244683remainder
remainders1354023remainders
remained112412893remained
remake124016113rema_ke
remaker133813173remaker
remakers143811303remakers
remanding132211143remanding
remanent10311703remanent
remanned11319353remanned
remap95418103rema__p
remark123512373rema_rk
remarry1235193remarry
rematch1436193rematch
remate84428683rema_te
remated103522473remated
remedy1237863rem_edy
remeets93712413remeets
remelts93511493remelts
remended123010393remended
remiges103015473remiges
reminded123411523reminded
reminder113110513reminder
reminders12308653reminders
remint85329973remin_t
remises93423483remises
remiss84216353rem_iss
remits85622943rem_its
remixes164313873remixes
remnant9312633remnant
remold93412973remold_
remoras9314073remoras
remotes94521613remotes
remounts1036373remounts
removes124514713removes
rems66237723rem___s
remuda936823rem_uda
remudas1035833remudas
renails74917263renails
renames92418053renames
rend56136573re__nd_
renins64526453renin_s
rents55935183re__nts
repacks15269543repacks
repaid94716323repaid_
repaints1038483repaints
repairs9319973repairs
repandly1445013repandly
repanel939963repanel
repanels1036783repanels
reparks13249513reparks
repass84114703repa_ss
repasts93611933repasts
repaves123513653repaves
repays113813973repa_ys
repents93717623repents
repines94927383repines
repins84924313repin_s
replans92814943replan_s
replants102811243replants
reprimands1572483reprimands
reracks132310533reracks
reran57329103reran__
rereads81512293rereads
rereminds1244353rereminds
rerents73319423rerents
reruns66413743rerun_s
resaid74517083resaid_
resails74616743resails
resales74724903resales
resaws93713513resa_ws
resays93714153resa_ys
rescinds1136333rescinds
reseeds84012333reseeds
resend75016773resend_
resents74221223resents
resids74219153re_sids
resins64528773resin_s
resods74116303re_sods
resounds956483resounds
responds1136913responds
retacks132210713retacks
retags73414303reta_gs
retails74718973retails
retains74522253retains
retakes113718863retakes
retapes93917423retapes
retard75018933retard_
retaxes143615093retaxes
retenes76324623retenes
retinas74819353retinas
retines75134673retines
retints74717013retints
retunes76918403retunes
revamps1433993revamps
rewakes144614983rewakes
rewan85623663rewan__
reward106017633reward_
rewarms12439593rewarms
rewaxes173911333rewaxes
reweds104412303re_weds
rewelds11457413rewelds
rewind104715883rewind_
rewins95020823rewin_s
rewords115413973rewords
rexines144719153rexines
reynards1244303reynards
rezones163213943rezones
rhamnus1233133rhamnus
ribalds10236673ribalds
riband9239623riband_
ribbands1344563ribbands
rimland1035663rimland_
rinds64826143r__inds
ritards8439943ritards
roads66523613r_oa_ds
roans54926443r_oan_s
roband92310723roband_
romaines10512513romaines
romajis1635903romajis
roman75424823roman__
romance11311083romance
romances12310793romances
romanise10312133romanise
romano84912943roman_o
romaunts1043693romaunts
rounds73615613r_ounds
rowans95715343rowan_s
ruanas6311263r_uanas
rumakis1335523rumakis
rumens83611813rumen_s
rynds9569973r__ynds
sands65228583__sands
secants93413893secants
seconds1038283seconds
sedans74816093sedan_s
semens84616963semen_s
sends65528243se__nds
sewans95215903sewan_s
solands84412343solands
somans84619303soman_s
stands75118053_stands
strands83711953strands
summands1344713summands
tamandu1044423tamandu
tamandus1143943tamandus
teinds738263te_inds
tenants7311013tenants
tends65425583te__nds
tetanus737933tetanus
tomans85419133toman_s
treads74817913tre_a_ds
trends75513543tre__nds
trepangs11205403trepangs
trepans92311593trepan_s
trolands936413trolands
unhands1137773unhands
unmans82211993unman_s
uplands1036943uplands
vegans103910853vegan_s
vends95520893ve__nds
veranda1156323veranda
verandas1246233verandas
viands1047813_viands
wands96425483__wands
wealds10459103we_alds
weans85326743we_an_s
weasands1244563weasands
weazands2143333weazands
wends95822813we__nds
wessands1243673wessands
wetlands1244763wetlands
womans114613653woman_s
yeans86624883ye_an_s
zenanas16286233zenanas

Search took 9 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.1561145455.1
2DLD Change Limit1340274587.84317088.7
3Display Results4584580.1732647.4
 (SQL Overall)1786914588.17221866.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.