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 “pinas” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

284 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
pinas7543445(None) 
kinas95626911kinas
minas75434111minas
pians75126961pians
pias66542551pi_as
picas94626521picas
pikas114218091pikas
pimas94725101pimas
pina65842631pina_
pines76048861pines
pings85830881pings
pinks115729381pinks
pinnas85315511pinnas
pins65558451pin_s
pintas85021391pintas
pints75936221pints
pitas77427671pitas
punas74826751punas
vinas85126341vinas
ains46158882ain_s
anas46649862_anas
annas55824882annas
bias64738162bi_as
bimas95521742bimas
binal75323822binal
binds86627472binds
bines76946792bines
bins66548252bin_s
bints76130182bints
bunas75126572bunas
chinas115119402chinas
cines75239682cines
dinar66319892dinar
dinars75417562dinars
dines66449152dines
dings76331402dings
dinks105927952dinks
dinos65428062dinos
dins56652042din_s
dints67431312dints
ditas65923672ditas
divas95418582divas
donas65926472donas
epinaos936282epinaos
etnas54713932etnas
final83922032final
finals94316162finals
fincas113512072fincas
finds95424822finds
fines86644262fines
finis86824262finis
finks125424222finks
finos86226952finos
fins75849092fin_s
gigas75415582gigas
ginks104319562ginks
gins55543952gin_s
hinds96721472hinds
hins76447992hin_s
hints87330622hints
inks86926502_inks
inns46920932_inns
ins35945602_in_s
jinks165019332jinks
jinns126013842jinns
jins115635012jin_s
kanas95326912kanas
kina85631992kina_
kinase104210652kinase
kinds106221812kinds
kines95039132kines
kings105825562kings
kinks84926082kinks
kinos96626142kinos
kins85747902kin_s
kivas124614732kivas
lianas63713382lianas
limas75627632limas
linac7315412linac
linacs8310812linacs
lines57054572lines
lingas75116572lingas
lings67135772lings
links96430192links
linns56123332linns
linos55631502linos
lins47059052lin_s
lints57137192lints
liras56021982liras
litas54923772litas
lunas55025012lunas
manas76240432manas
micas96823052micas
mina65136922mina_
minae75627722minae
minds85427122minds
mines75651952mines
minis75432992minis
minks115829272minks
mints76834042mints
minus75223932minus
monas74732152monas
mynas105815232mynas
nanas55928632nanas
nines55937342nines
ninjas1386302ninjas
nipas77116672nipas
nonas55126652nonas
oinks94819912oinks
opines84820702opines
pacas96029402pacas
pains75138282pain_s
paints85921832paints
paisas84317492paisas
pandas95521962pandas
panes76148692panes
pangas99921102pangas
pangs84628662pangs
pans65855732pan_s
pants76536922pants
papas94927492papas
paras76143042paras
pas58775742p__as
patinas96318522patinas
peans75437642peans
peas65755062p_eas
peins76128062pein_s
penal75228372penal
pends85527192pends
penes75839222penes
penis75129322penis
pens65649642pen_s
pia56848032pi_a_
pial65636702pi_al
pian66136092pi_an
piano76118712piano
pianos84315932pianos
pibal95217322pibal
pibals103813082pibals
pica85831492pica_
pical95524372pical
picks135226142picks
pics85633912pi_cs
piers75926332piers
pies66949602pi_es
pietas84516502pietas
pignus937952pignus
pigs76634222pi_gs
pika106322952pika_
pikes115031032pikes
pikis115116392pikis
pilaf103923482pilaf
pilafs113511022pilafs
pilar75221502pilar
pilau73618522pilau
pilaus84114132pilaus
pilaw103913742pilaw
pilaws11399432pilaws
piles74742612piles
pilis75825202pilis
pills74130972pills
pilus75921062pilus
pima85428652pima_
pimps114616982pimps
pin57066722pin__
pinang92611592pinang
pinangs10267792pinangs
pinata83817222pinata
pinatas93711502pinatas
pinch125619302pinch
pine67755712pin_e
pineal84817682pineal
pineals93212842pineals
pined85935322pined
piney105727502piney
ping75943592pin_g
pingo87122712pingo
pingos95317672pingos
pink107039382pin_k
pinko115618252pinko
pinkos125313872pinkos
pinky145823402pinky
pinna75320182pinna
pinnae84414642pinnae
pinnal84814272pinnal
pinny105222062pinny
pinon76024532pinon
pinons86019942pinons
pinot78737292pinot
pinots85920272pinots
pint66963172pin_t
pinta75727052pinta
pinto75625752pinto
pintos86021292pintos
pinup9612882pinup
pinups1037412pinups
piny911838352pin_y
pions75826392pions
pious74621272pious
pipal95118352pipal
pipals104213642pipals
pipes96030142pipes
pips85837132pi_ps
piranas9912602piranas
pirns76020092pirns
pis56362032pi__s
pisos76021062pisos
piss65033332pi_ss
pita65436432pita_
piths105817542piths
pits66348742pi_ts
pittas86014522pittas
pixes144323172pixes
pizzas1646982pizzas
plans75731272plans
pleas75627032pleas
plinks124913262plinks
poinds93511142poinds
points85618532points
ponds85323402ponds
pones74547042pones
pongs85526342pongs
pons65850602pon_s
primas104418102primas
prinks124315382prinks
prints84320102prints
proas75028802proas
psoas75012982psoas
pujas145513322pujas
pumas95121562pumas
puna65331652puna_
pungs85422222pungs
punkas123410672punkas
punks114822682punks
puns66641482pun_s
punts75828002punts
pupas95219282pupas
pyas96225702p_yas
pyins105815862pyin_s
rias45540592ri_as
rinds64826142rinds
rings65029172rings
rinks94827102rinks
rins46153192rin_s
sikas94617022sikas
simas75727552simas
sines55954822sines
sings65532702sings
sinhs86719602sinhs
sinks95529182sinks
sins46755272sin_s
sinus55523852sinus
spicas104715822spicas
spinal84915312spinal
spinals93911862spinals
spines85132032spines
spins75327982spin_s
tineas64616482tineas
tines54848422tines
tings65329202tings
tins45251302tin_s
tints56030922tints
tunas54224122tunas
ulnas55716532ulnas
vigas94817882vigas
vina76331802vina_
vinal85725812vinal
vinals94716482vinals
vincas113912452vincas
vines85137642vines
vinos84723072vinos
visas84317652visas
vivas114815022vivas
winds95425602winds
wines85546862wines
wings95727242wings
winks125325432winks
winos84625042winos
wins75949172win_s
yins75335122yin_s
zincs165312932zincs
zines145232652zines
zings154620892zings
zins135735002zin_s

Search took 4 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 Filter178691538000.186960704.3
2DLD Change Limit538002843.50015371.4
3Display Results2842840.1701670.6
 (SQL Overall)1786912843.85646341.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.