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

198 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
piso6672757(None) 
miso67229911miso
peso66925821peso
pis56362041pis_
pisco96314981pisco
pish96127921pish
pisos76021061pisos
piss65033341piss
ais39083582ais_
also46423442also
apish105116642apish
aviso85713962aviso
bio57846092bi_o
bios66335332bios
biro66131222biro
bis56860672bis_
bise66437112bise
bisk106523362bisk
bison75716982bison
ciao64924192ciao
cis57748042cis_
cisco95112132cisco
cist67244972cist
dido66528212dido
dino56036762dino
dipso85111552dipso
dis46459902dis_
disc76123242disc
disco85616072disco
dish86328342dish
disk96625842disk
diss56434492diss
fico95824602fico
fido87726412fido
filo76034292filo
fino76034702fino
fisc96819762fisc
fish106926282fish
fist76248432fist
giro55828642giro
gismo848862gismo
gist56046772gist
his66359512his_
hisn79620942hisn
hiss75629222hiss
hist76551552hist
is27048222_is_
ism56322392_ism
jiao115017852jiao
jism135514782jism
kilo86028682kilo
kino86233632kino
kis78051492kis_
kiss85227412kiss
kist86540812kist
lido56028172lido
lilo46731572lilo
limo65529742limo
lino46343382lino
lis37162282lis_
lisp68926892lisp
list47055352list
milo65536112milo
mis58162632mis_
misdo85413192misdo
mise66043592mise
misos76523292misos
miss65339432miss
mist66154542mist
nisi45823252nisi
paisa76021072paisa
paise75028332paise
pas58775742pas_
pase65346862pase
paseo77022512paseo
pash95638132pash
pass65239952pass
past65959012past
peise75825772peise
pepo87622152pepo
pes57259782pes_
pesos77221622pesos
pest65555292pest
pesto75723722pesto
phis95724902phis_
pi48145372pi__
pia56848042pi_a
pial65636712pial
pian66136102pian
piano76118712piano
pias66542562pias
pic76046832pi_c
pica85831502pica
pice84641102pice
pick125933822pick
picot95031012picot
pics85633922pics
pie55457412pi_e
pied75035372pied
pier66035302pier
pies66949612pies
pig65744982pi_g
pigs76634232pigs
pika106322962pika
pike106335222pike
piki106520572piki
pile65649702pile
pili66130362pili
pill65339472pill
pilot77435062pilot
pily96132742pily
pima85428662pima
pimp106024912pimp
pin57066732pi_n
pina65842642pina
pine67755722pine
ping75943602ping
pingo87122712pingo
pink107039392pink
pinko115618252pinko
pinon76024532pinon
pinot78737292pinot
pins65558462pins
pint66963182pint
pinto75625752pinto
piny911838362piny
pion67235302pion
pip78051052pi_p
pipe86434442pipe
pips85837142pips
pipy115421522pipy
pirn67128382pirn
pirog83913672pirog
piscos105112592piscos
piste75824602piste
pistol83313332pistol
piston83515922piston
pistou83211842pistou
pit56471932pi_t
pita65436442pita
pith95432702pith
piton76121582piton
pits66348752pits
pity96031942pity
piu56639552pi_u
pivot106523872pivot
pix126437942pi_x
pixy166117772pixy
poco86826152poco
pois66539042pois_
poise75127892poise
poison8312222poison
polo66236632polo
pomo85828452pomo
poo57757112p_oo
poos65949112poos
pose66441732pose
posh95427322posh
post67953362post
posy96028422posy
prao66229022prao
primo95017912primo
prise74632612prise
prism94820262prism
prison8514022prison
priss74623892priss
pro55837262p_ro
pros65742782pros
proso77222412proso
psi56621622p_si
psis68120342psis
psst66118402psst
pst57932512p_st
pus55547842pus_
push95526622push
puss64830132puss
pyro96019392pyro
qis126934392qis_
rise45945242rise
risk85724112risk
silo46037922silo
sis37360552sis_
so28855442__so
tiro46832372tiro
tis37056652tis_
vino76128442vino
vis66747622vis_
visa76323882visa
vise75632682vise
visor82512832visor
wino75933622wino
wis66552342wis_
wise75737352wise
wish107228742wish
wisp97124082wisp
wiss75630552wiss
wist78049302wist
xis106935342xis_

Search took 3 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.500357382.0
2DLD Change Limit298721981.87315948.7
3Display Results1981980.0464304.3
 (SQL Overall)1786911982.41973869.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.