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

320 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
pina6584263(None) 
kina85631991kina
mina65136911mina
pia56848031pi_a
pian66136091pian
pica85831491pica
pika106322951pika
pima85428651pima
pin57066721pin_
pinas75434451pinas
pine67755711pine
ping75943591ping
pink107039381pink
pinna75320181pinna
pins65558451pins
pint66963171pint
pinta75727051pinta
piny911838351piny
pita65436431pita
puna65331651puna
vina76331801vina
ain37579092ain_
ains46158882ains
ana39559822_ana
anna45529012anna
apian75018332apian
aping87327232aping
bima86723832bima
bin56658642bin_
binal75323822binal
bind76234512bind
bine66650862bine
bins66548252bins
bint67355042bint
buna64730722buna
china105022472china
cine66242942cine
din46459462din_
dinar66319892dinar
dine55555332dine
ding66940952ding
dink97137802dink
dino56036752dino
dins56652042dins
dint56759052dint
dita56032522dita
diva85920882diva
dona55529632dona
etna46415262etna
fila74729132fila
fin66458032fin_
final83922032final
finca104714502finca
find87532602find
fine75147952fine
fink117532122fink
fino76034692fino
fins75849092fins
giga66720942giga
gin46055752gin_
gink97129522gink
gins55543952gins
hila76228352hila
hin67559562hin_
hind85529752hind
hins76447992hins
hint77455742hint
in28150862_in_
inia45024702_inia
ink76433632_ink
inn36727432_inn
ins35945602_ins
jin106443932jin_
jink156227202jink
jinn115420242jinn
jins115635012jins
jinx185516572jinx
kana85928522kana
kin76353962kin_
kinas95626912kinas
kind96128552kind
kine85643422kine
king95933652king
kink76034392kink
kino86233612kino
kins85747902kins
kiva116516402kiva
kuna85120702kuna
liana53915892liana
lima65734132lima
lin37967372lin_
linac7315412linac
line46965572line
ling57447962ling
linga66820812linga
link86943442link
linn46034592linn
lino46343372lino
lins47059052lins
lint416266232lint
liny78141322liny
lipa68425922lipa
lira46928682lira
luna46229852luna
mana65341942mana
mica86428252mica
minae75627722minae
minas75434112minas
mind75434372mind
mine67256162mine
mini65634552mini
mink106636522mink
mint66758052mint
minx137723342minx
myna95815292myna
na28652482__na
nana46632892nana
nine45842172nine
ninja1258092ninja
nipa69421632nipa
nona46929062nona
oink85429342oink
opine77422462opine
oping86322412oping
pa410456482p__a
paca85132242paca
pain65647242pain_
pains75138282pains
paint75443692paint
paisa76021072paisa
pan58466442pan_
panda85022612panda
pane64950282pane
pang75336282pang
panga85323532panga
pans65855722pans
pant66061252pant
papa85827142papa
para65242172para
patina86022192patina
pea56657242p_ea
pean66147172pean
pein65834942pein_
peins76128062peins
pen56558842pen_
penal75228372penal
pend75934532pend
penna74520202penna
pens65649642pens
pent66559072pent
pi48145362pi__
pial65636702pial
piano76118712piano
pians75126962pians
pias66542552pias
pibal95217322pibal
pic76046822pi_c
pical95524372pical
picas94626522picas
pice84641092pice
pick125933812pick
pics85633912pics
pie55457402pi_e
pied75035362pied
pier66035292pier
pies66949602pies
pieta75421752pieta
pig65744972pi_g
pigs76634222pigs
piing85218832piing
pikas114218092pikas
pike106335212pike
piki106520562piki
pilaf103923482pilaf
pilar75221502pilar
pilau73618522pilau
pilaw103913742pilaw
pile65649692pile
pilea75123952pilea
pili66130352pili
pill65339462pill
pily96132732pily
pimas94725102pimas
pimp106024902pimp
pinang92611592pinang
pinata83817212pinata
pinch125619302pinch
pineal84817682pineal
pined85935322pined
pines76048862pines
pineta85815562pineta
piney105727502piney
pingo87122712pingo
pings85830882pings
pinko115618252pinko
pinks115729382pinks
pinky145823402pinky
pinnae84414642pinnae
pinnal84814272pinnal
pinnas85315512pinnas
pinny105222062pinny
pinon76024532pinon
pinot78737292pinot
pintas85021392pintas
pinto75625752pinto
pints75936222pints
pinup9612882pinup
pion67235292pion
pions75826392pions
pip78051042pi_p
pipal95118352pipal
pipe86434432pipe
pips85837132pips
pipy115421512pipy
pirana8713262pirana
pirn67128372pirn
pirns76020092pirns
pis56362032pi_s
pish96127912pish
piso66727562piso
piss65033332piss
pit56471922pi_t
pitas77427672pitas
pith95432692pith
pits66348742pits
pitta75018692pitta
pity96031932pity
piu56639542pi_u
pix126437932pi_x
pixy166117762pixy
pizza1538182pizza
plan65833942plan
plea66830602plea
plena75816392plena
plica9613372plica
plink115219122plink
poind84217912poind
point75338732point
pond75530492pond
pone65747532pone
pong76231142pong
pons65850602pons
pony96434052pony
prima95019342prima
prink114719672prink
print74837462print
proa66229962proa
puja135714922puja
pula65129372pula
puma85424122puma
pun58846512pun_
punas74826752punas
pung75429632pung
punk105729972punk
punka114515482punka
puns66641482puns
punt65747202punt
puny95526992puny
pupa85422812pupa
pya87023752p_ya
pyin96823232pyin_
pyins105815862pyins
ria36745502ri_a
rin36663182rin_
rind56535602rind
ring56541152ring
rink87736992rink
rins46153192rins
signa66114702signa
sika86021322sika
sima64730782sima
sin36265892sin_
sine46560622sine
sing57544172sing
sinh76238042sinh
sink86640142sink
sins46755272sins
spica94717942spica
spin66231302spin_
spinal84915312spinal
spine76534422spine
spins75327982spins
spiny104921302spiny
tin36362172tin_
tine45855132tine
tinea54923152tinea
ting56139892ting
tins45251302tins
tint46758862tint
tiny76134632tiny
tuna45127842tuna
ulna46317322ulna
vena76126292vena
via65636242vi_a
viga85622962viga
vinal85725812vinal
vinas85126342vinas
vinca105315162vinca
vine75643682vine
vino76128432vino
viny106025952viny
visa76323872visa
vita75828522vita
viva106119092viva
win66456292win_
wind85533852wind
wine74953422wine
wing86339222wing
wink116435022wink
wino75933612wino
wins75949172wins
winy107034322winy
yin67648732yin_
yins75335122yins
zin125643772zin_
zinc156819092zinc
zine137036152zine
zing145728612zing
zins135735002zins
zona136321962zona

Search took 2 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 Filter178691298720.0762351197.4
2DLD Change Limit298723201.06328101.6
3Display Results3203200.0764210.5
 (SQL Overall)1786913201.215147070.8
 
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.