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

429 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
portals9401556(None) 
mortals93914001mortals
portal84218461portal_
postals93716371postals
aortal65217512aortal_
aortas65417782aorta_s
borals86721912bor_als
borstals1037462borstals
corals85325142cor_als
corrals93713852corrals
curtals93111622curtals
dorsals84110842dorsals
formals123312892formals
gorals76917652gor_als
hartals10313022hartals
morals85324632mor_als
mortal84616852mortal_
mortars93411522mortars
normals92510902normals
orals55826482_or_als
parrals94414572parrals
partans94418282partans
partials101911952partials
petals84719812p_etals
pontils9312212pontils
portable12313202portable
portables1337872portables
portably1539312portably
portage103013642portage
portages112613222portages
portaled11239202portaled
porters93722702porters
portly114713402port_ly
portrays1345292portrays
ports75934592port__s
postal84317532postal_
protyls12298462protyls
tortas64918252torta_s
totals63115162to_tals
acetals93411353acetals
aerials74017553aerials
aorta55922573aorta__
aortae65115473aorta_e
aporias9315153aporia_s
apostils1046773apostils
argals75517713_argals
artal55525473_artal_
artels66216233_artels
astrals75515243astrals
boatels93510233boatels
bobtails1245193bobtails
boral75831703bor_al_
boras75938303bor_a_s
borates94823013borates
bordels103911973bordels
boreal84817213boreal_
boreas85421733borea_s
borstal939043borstal_
borts76735453bort__s
bortzes1838223bortzes
botas75328783bo_ta_s
botels84815803bo_tels
bromals1139743bromals
burials93612083burials
buttals938503buttals
cantals93919573cantals
caporals1238923capor_als
carpals113414623carpals
cartels94618123cartels
centals94317053centals
cereals9313173cereals
chorals124614113chor_als
citrals91111673citrals
coals76129603co__als
coevals1237873coevals
coital84117053coital_
copals105018943co_pals
coral76033453cor_al_
corbans11313173corbans
corbels113813593corbels
cordials1139623cordials
cormels113813373cormels
cornels94716663cornels
coronals103312893coronals
corral83616253corral_
corsacs1139013corsacs
cortins92421333cortins
costal85419513costal_
costars94218013costars
cotans81317923co_tans
cottars94412243cottars
cottas84615573cotta_s
craals84113303_craals
curtails10318243curtails
curtal83914543curtal_
dentals83915393dentals
dorsal74613943dorsal_
dorsels84412573dorsels
dossals8379293dossals
dotal64919623do_tal_
dottels8327783dottels
farfals13268503farfals
ferals94216643fer_als
florals104210063flor_als
foals85721693fo__als
foetal9311883foetal_
fontal9313143fontal_
forams115115913for_ams
forays124813003for_ays
formal113215203formal_
formats123113573formats
formols12299413formols
formyls15235703formyls
fortes95327183fort_es
forties104323863forties
fortis95418613fort_is
forts86034453fort__s
foxtails1844583foxtails
frontals1146273frontals
goals65521293go__als
goorals838703goorals
goral65125753gor_al_
graals74112913_graals
hartal9415473hartal_
herbals122710603herbals
horahs126313873hor_ahs
horal86328683hor_al_
horas86333103hor_a_s
horntails12124823horntails
hostas94515823hosta_s
hostels103712313hostels
hotels94515513ho_tels
immortals1343803immortals
instals7611713instals
iotas54821113io_ta_s
jorams154810533jor_ams
jordans1566833jordans
jotas125717443jo_ta_s
jouals1338923jo_uals
journals1574353journals
koras95927113kor_a_s
korats105416063kor_ats
kormas124511233korma_s
kraals10378433_kraals
kurtas10349883kurta_s
locals83714503lo_cals
loral55927823lor_al_
lorans65117603lor_ans
loreal63814313loreal_
lotahs9479873lo_tahs
lotas55926303lo_ta_s
metals84520883_metals
modals93914453mo_dals
moral75533433mor_al_
morale85220553mor_ale
morales93619403mor_ales
moras76438783mor_a_s
morass84614503mor_ass
morays114613883mor_ays
morels84820013mor_els
morgans10310123morgans
morsels94112653morsels
mortally1339933mortally
mortar83812043morta_r
mortary12369043mortary
morts75533563mort__s
morulas959713morulas
motels83616893mo_tels
murals84016763mur_als
narwals1036983narwals
nopals84914023no_pals
norias65518203noria_s
normal83213533normal_
norths96812323nort_hs
notal55221353no_tal_
octads987333_octads
octal71214723_octal_
octans81411143_octans
octyls11135323_octyls
offals1235893_offals
oorali6311263oor_ali
ooralis7312553oor_alis
opals75718353_o_pals
oral47638123_or_al_
orates64328613_orates
orbitals1045713_orbitals
orcas75918623_orca_s
ordeals877993_ordeals
oreads73915773_oreads
organs7912913_organs
oriels64914623_oriels
orts46538333_ort__s
ottars64112223_ottars
ovals85413393_o_vals
oxtails1436383_oxtails
palatals1037773palatals
pals66951353p___als
paras76143043par_a_s
parcels113712663parcels
pardahs13289673pardahs
pariahs123812343pariahs
parians93519733parians
parietals1146863parietals
parkas125018023parka_s
parlays123910453parlays
parols84722613par_ols
parral85517533parral_
parrels94713493parrels
partake1339643partake
partakes1449923partakes
partan83820563parta_n
partial92616263partial_
parties93230863parties
partly116315473part_ly
partons94620513partons
parts77743373part__s
pascals11610013pascals
pastas85422873pasta_s
pastels95215183pastels
pastils94416173pastils
patrols93513513patrols
peals75235493p__eals
pedals94316033p_edals
pentads1039523pentads
pentyls1236523pentyls
peptalk1554823peptalk
peptalks1653843peptalks
percale11314093percale
percales12313803percales
perhaps1446123perhaps
perils84121853per_ils
persalt9315413persalt
persalts1038193persalts
pertain92714963pertain
pertains102113423pertains
pertly115312553pert_ly
perusals1047143perusals
petal76526893p_etal_
petrale9312623petrale
petrales10312983petrales
petrels9279373petrels
petrols92913083petrols
peytrals1355493peytrals
phials1158873p_hials
phorates13413043phorates
phreaks1634543phreaks
phytols15276553phytols
pibals103813083p_ibals
pietas84516503pieta_s
pigtails1146033pigtails
pineals93212843pineals
pintails10310163pintails
pintas85021393pinta_s
pipals104213643p_ipals
pirates93020333pirates
pistils93314303pistils
pistols93213983pistols
pitas77427673p_ita_s
pittas86014523pitta_s
platans93413123platans
plurals936913plurals
podsols1056513podsols
podzols1934683podzols
poetess938933poetess
poetics11312073poetics
poets76024443poet__s
poitrels1035243poitrels
polars84419353po_lars
polkas1239103polka_s
polls74627723po__lls
pols66044563po___ls
polyols1238493polyols
pommels13235783pommels
pontes83627853pont_es
pontil8315463pontil_
pontons93315553pontons
ponytails1443653ponytails
pooftahs1642363pooftahs
pools74427703po__ols
poplars113910333poplars
poppas93710713poppa_s
porches143815673porches
pores75849033por__es
porgies103017003porgies
porisms113713453porisms
porkers134314933porkers
porkies133416493porkies
porks115124143por__ks
pornos85015253por_nos
porns75527343por__ns
porous84419483por_ous
port66059633port___
portaged12228463portaged
portance12310113portance
portances1349833portances
portapak1642343portapak
portapaks1742133portapaks
ported94223243port_ed
portend103411193portend
portends11358963portends
portent93619643portent
portents103512823portents
porter84224413port_er
porthole1349523porthole
portholes14410373portholes
portico11310143portico
porticos1238373porticos
porting103021783porting
portion9615493portion
portions10514413portions
portless10310643portless
portrait10510323portrait
portraits1146803portraits
portray1237483portray
portrayals1552003portrayals
portress1038323portress
postage103214853postage
postages112815323postages
postally13310273postally
postbags1345293postbags
posters93928013posters
posties93128813posties
postins93721203postins
postops11311713postops
posts75228783post__s
potable112115363po_table
potables12179703po_tables
potage92715903po_tage
potages102416423po_tages
potash1138273po_tash
potato8513433po_tato
potfuls1236293potfuls
pothos114214693po_thos
pots66452363po_t__s
pottage103310603pottage
pottages112910453pottages
potters94024343potters
potties93723543potties
pottle84416103po_ttle
pottles93816983pottles
pottos84615873po_ttos
poundals1145013poundals
pouters94221873pouters
pouts75530323pout__s
powters124015663powters
praams10459643p_raams
prams96125513p_r_ams
praos74923563p_r_aos
prates84633163p_rates
prats76333393p_r_ats
praus74621753p_r_aus
prays105022433p_r_ays
prills84015613p_rills
proas75028803p_roa_s
prolans9314273prolans
propels113412843propels
propyls14308193propyls
prorates10418073prorates
protases102115033protases
protasis102411973protasis
proteans102811543proteans
proteas92015123proteas
proteus92511593proteus
protons93118003protons
protyl11308213protyl_
protyle12229453protyle
protyles13249833protyles
prowls115511083p_rowls
purdahs13285483purdahs
purdas92612263purda_s
puritans1037633puritans
purls74723353pur__ls
pyrans11411063pyr_ans
pyrolas1239863pyrolas
pyrrols1235403pyrrols
ratals64219583_ratals
reals55038653__reals
rentals74017473rentals
rials55026673__rials
rorquals1773173rorquals
rotas54827723ro_ta_s
rotls55620163ro_t_ls
royals93711263ro_yals
serials73919743serials
servals103410743servals
socials999633socials
softas94410403softa_s
soras55041013sor_a_s
sorels63921163sor_els
sorrels7310723sorrels
sorta57125413sorta__
sortable10312483sortable
sortably1338803sortably
sorters74221133sorters
sorties74126403sorties
sorts54536663sort__s
sotols63714473so_tols
spirals93212513spir_als
spitals93011593spitals
sporal82915453spor_al_
sporrans1045523sporrans
sporters103714063sporters
sportily1337733sportily
sports84619183sport__s
spousals1064353spousals
tarsals72512603tarsals
tartans72615823tartans
tartars73313403tartars
tertials8510073tertials
torahs95115643tor_ahs
toras55540373tor_a_s
torta55925353torta__
tortes64826053tort_es
tortile7313193tortile
torts56138123tort__s
torulas759853torulas
total55321823to_tal_
trials64319883_trials
trotyls10236033trotyls
uprootals1142643uprootals
urials64415193_urials
verbals121910743verbals
vestals104612333vestals
vitals94514303_vitals
vocals113811583vo_cals
wormils1236733wormils
worths127812893wort_hs
worts88631183wort__s
zorils153810883zor_ils

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 Limit1340274296.81319672.2
3Display Results4294290.1562750.0
 (SQL Overall)1786914297.35924282.0
 
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.