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

330 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
pinangs1026779(None) 
penangs10268371penangs
pinang92611591pinang_
finings114311772finings
inanes62519802_inanes
kiangs11378362ki_angs
liangs74410592li_angs
linings84313072linings
linsangs944412linsangs
minings103912072minings
pangs84628662p__angs
parangs104314372parangs
penang92511112penang_
pianos84315932pi_anos
pians75126962pi_an_s
pilings103313612pilings
pinas75434452pina__s
pinatas93711502pinatas
pinenes93416672pinenes
pings85830882pi__ngs
pining93726532pining_
pinkings15338142pinkings
pinnas85315512pin_nas
pinones94717072pinones
pinons86019942pinon_s
pintanos10107552pintanos
pipings12338252pipings
piranas9912602piranas
prangs94816232p_rangs
airings83913843airings
awnings11406713awnings
bananas93312223bananas
bangs85627773__bangs
bhangs12449663_bhangs
bindings123810473bindings
changs125215373_changs
clangs95113613_clangs
dangs75623203__dangs
defangs1235363defangs
dinars75417563dina_rs
dings76331403di__ngs
dining84525133dining_
divans104612393divan_s
diwans105110373diwan_s
epinaos936283epina_os
fangs96224073__fangs
filings115213073filings
finales104016013finales
finalis103313663finalis
finals94316163fina_ls
finance1238573finance
finances1338653finances
findings13328443findings
fining104223213fining_
firings114112333firings
fixings18347443fixings
gangs76222573__gangs
giants74713503gi_ants
ginnings10366523ginnings
ginsengs1042653ginsengs
gitanos837173gitanos
gobangs11385833gobangs
hangs95726723__hangs
hidings12349703hidings
honans94814503honan_s
icings9428453_icings
inane52820343_inan_e
inaner62213543_inaner
inanest72115363_inanest
inarms8410093_inarms
incants92012803_incants
incogs937903_incogs
infants102210773_infants
inlands838783_inlands
innage73011573_innage
innages82911303_innages
innings8329443innings
inns46920933_in_n_s
jinnis13489053jin_nis
jinns126013843jin_n_s
jnanas13207303_jnanas
joinings16285243joinings
kiang104811353ki_ang_
kinaras1159123kinaras
kinas95626913kina__s
kinases113511123kinases
kings105825563ki__ngs
kinins104014583kinin_s
lianas63713383li_anas
lianes63819323li_anes
liang64914413li_ang_
ligands9438983ligands
ligans76817733ligan_s
lignans8398853lignan_s
likings12539413likings
limans84816303liman_s
linacs8310813lina_cs
linage7713403lina_ge
linages8813173linages
lindanes939173lindanes
linens64818393linen_s
lings67135773li__ngs
lining74526803lining_
linins65922143linin_s
linns56123333lin_n_s
linsang835863linsang_
livings11408923livings
mananas93414733mananas
minas75434113mina__s
mining94225453mining_
minyans1237263minyan_s
nags55436023__na_gs
nanas55928633__nanas
nans46139403__nan_s
ninons64913773ninon_s
openings1134803openings
opining10311743opining_
orangs74116033_orangs
ourangs8318503ourangs
padnags1135083padna_gs
paeans85118263paean_s
pagans95717923pagan_s
pagings114411063pagings
paining103920243paining_
paintings12327093paintings
pairings11398313pairings
paisanas10288873paisanas
paisanos10337553paisanos
paisans93614753paisan_s
palings103915823palings
panadas103312213panadas
panamas113112763panamas
pandanus1136433pandanus
panes76148693p__anes
pang75336293p__ang_
panga85323533p__anga
pangas99921103p__angas
pannes85522853pan_nes
pans65855733p__an_s
pants76536923p__ants
parang93715513parang_
parings104219213parings
pavanes123612653pavanes
pavans115715593pavan_s
pavings134011633pavings
peags86122843p_ea_gs
peans75437643p_ean_s
pecans101515833pecan_s
pedants10310113pedants
peining104619153peining_
pekans121710553pekan_s
penance11313443penance
penances12312443penances
penates93321603penates
pendants1139093pendants
pennants1037063pennants
pennis84315743pen_nis
pentanes10316083pentanes
pian66136093pi_an__
pianic103714123pi_anic
pianism11611033pi_anism
pianist9615103pi_anist
piano76118713pi_an_o
pias66542553pi_a__s
pibals103813083piba_ls
picante11310523picante
picaras11311283picaras
picaros11310893picaros
picas94626523pica__s
pickings17359383pickings
piecings1345343piecings
pieing93917653pieing_
pignus937953pi_gnus
pigs76634223pi___gs
piing85218833pi_ing_
pikakes1245823pikakes
pikas114218093pika__s
piking133719643piking_
pilaffs15365153pilaffs
pilafs113511023pila_fs
pilaus84114133pila_us
pilaws11399433pila_ws
piling95025593piling_
pimas94725103pima__s
pina65842633pina___
pinata83817223pina_ta
pinballs1246933pinballs
pinbones1238143pinbones
pincers113916503pincers
pinches144117933pinches
pinders103720473pinders
pineals93212843pineals
pinelands1244933pinelands
pinene82915643pinen_e
pines76048863pi__nes
ping75943593pi__ng_
pingers104020743pingers
pinging113419553pinging_
pingo87122713pi__ngo
pingoes105116523pingoes
pingos95317673pin_gos
pinions93413603pinions
pinites9319533pinites
pinkens13419643pinkens
pinkers134118603pinkers
pinkeys16378213pinkeys
pinkies133818263pinkies
pinking143918943pinking_
pinkness1436513pinkness
pinkoes135512313pinkoes
pinkos125313873pin_kos
pinks115729383pi__nks
pinna75320183pin_n_a
pinnace113510313pinnace
pinnaces12268863pinnaces
pinnae84414643pin_nae
pinnal84814273pin_nal
pinnate93613743pinnate
pinned94818383pin_ned
pinner84521503pin_ner
pinners93518603pinners
pinnies93318443pinnies
pinning103417853pinning_
pinny105222063pin_n_y
pinoles93418703pinoles
pinon76024533pinon__
pinots85920273pin_ots
pins65558453pi__n_s
pintadas11105083pintadas
pintados11105993pintados
pintails10310163pintails
pintano998993pintan_o
pintas85021393pin_tas
pintles94118723pintles
pintoes95117713pintoes
pintos86021293pin_tos
pints75936223pi__nts
pinups1037413pin_ups
pinwales1367963pinwales
pinyons12299003pinyons
pions75826393pi_on_s
pipage1199143pipa_ge
pipages1289423pipages
pipals104213643pipa_ls
piping114017453piping_
pirana8713263piran_a
piranha12126363piranha
piranhas13135873piranhas
pirates93020333pirates
pirayas1277483pirayas
pirns76020093pi_rn_s
pissants1097363pissants
pitas77427673pita__s
pitayas1286263pitayas
pitmans11188743pitman_s
pitons85319043piton_s
pittings11349123pittings
planes85028083p_lanes
planks124116753p_lanks
plans75731273p_lan_s
plants84921803p_lants
pongs85526343p__ongs
poontangs1242763poontangs
prang84820323p_rang_
pranks124814723p_ranks
primings13338143primings
printings12268103printings
probangs13256213probangs
prongs94314483p_rongs
ptisans9317363ptisan_s
pulings103511323pulings
punas74826753puna__s
pungs85422223p__ungs
puranas9712643puranas
pyrans11411063pyran_s
rehangs1137563rehangs
ribands10208393ribands
ridings93412093ridings
rings65029173ri__ngs
rinsings9318013rinsings
risings83211893risings
satangs8479713satangs
siamangs1144063siamangs
sidings94011463sidings
silanes72517163silanes
sings65532703si__ngs
sizings17378013sizings
slangs75615343_slangs
snags64421313_sna_gs
sonants7511233sonants
spilings11308813spilings
spinage10289653spina_ge
spinages11289293spinages
spinals93911863spina_ls
spinnings12294853spinnings
spirants1088283spirants
sprangs104610053sprangs
stangs75018163_stangs
tangs65028343__tangs
tenants7311013tenants
tidings93810263tidings
tilings84212793tilings
timings10279303timings
tings65329203ti__ngs
tining74927543tining_
tintings9288713tintings
tisanes7311853tisanes
titans63414913titan_s
twangs10358093_twangs
unhangs1136203unhangs
vangs96319583__vangs
veinings12306433veinings
viands1047813vi_ands
vikings15386623vikings
vinals94716483vina_ls
vinas85126343vina__s
vining104619463vining_
whangs13439723_whangs
wigans104511703wigan_s
windings13329973windings
wings95727243wi__ngs
wining103625053wining_
winnings12327583winnings
wirings113910113wirings
witans93412933witan_s
wrangs104611913_wrangs
yangs95618693__yangs
zananas16319563zananas
zenanas16286233zenanas
zings154620893zi__ngs

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.406440125.6
2DLD Change Limit1340273306.70319995.1
3Display Results3303300.1232682.9
 (SQL Overall)1786913307.23224708.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.