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
piso6672756(None) 
miso67229891miso
peso66925821peso
pis56362031pis_
pisco96314981pisco
pish96127911pish
pisos76021061pisos
piss65033331piss
ais39083572ais_
also46423442also
apish105116632apish
aviso85713962aviso
bio57846072bi_o
bios66335312bios
biro66131202biro
bis56860652bis_
bise66437092bise
bisk106523342bisk
bison75716982bison
ciao64924182ciao
cis57748032cis_
cisco95112132cisco
cist67244962cist
dido66528192dido
dino56036752dino
dipso85111552dipso
dis46459892dis_
disc76123232disc
disco85616072disco
dish86328332dish
disk96625832disk
diss56434482diss
fico95824592fico
fido87726392fido
filo76034282filo
fino76034692fino
fisc96819752fisc
fish106926272fish
fist76248422fist
giro55828632giro
gismo848862gismo
gist56046762gist
his66359502his_
hisn79620932hisn
hiss75629212hiss
hist76551542hist
is27048212_is_
ism56322382_ism
jiao115017842jiao
jism135514772jism
kilo86028662kilo
kino86233612kino
kis78051472kis_
kiss85227392kiss
kist86540792kist
lido56028152lido
lilo46731562lilo
limo65529732limo
lino46343372lino
lis37162272lis_
lisp68926872lisp
list47055342list
milo65536092milo
mis58162612mis_
misdo85413182misdo
mise66043572mise
misos76523292misos
miss65339412miss
mist66154522mist
nisi45823242nisi
paisa76021072paisa
paise75028332paise
pas58775742pas_
pase65346862pase
paseo77022512paseo
pash95638132pash
pass65239952pass
past65959012past
peise75825772peise
pepo87622152pepo
pes57259782pes_
pesos77221622pesos
pest65555292pest
pesto75723722pesto
phis95724902phis_
pi48145362pi__
pia56848032pi_a
pial65636702pial
pian66136092pian
piano76118712piano
pias66542552pias
pic76046822pi_c
pica85831492pica
pice84641092pice
pick125933812pick
picot95031012picot
pics85633912pics
pie55457402pi_e
pied75035362pied
pier66035292pier
pies66949602pies
pig65744972pi_g
pigs76634222pigs
pika106322952pika
pike106335212pike
piki106520562piki
pile65649692pile
pili66130352pili
pill65339462pill
pilot77435062pilot
pily96132732pily
pima85428652pima
pimp106024902pimp
pin57066722pi_n
pina65842632pina
pine67755712pine
ping75943592ping
pingo87122712pingo
pink107039382pink
pinko115618252pinko
pinon76024532pinon
pinot78737292pinot
pins65558452pins
pint66963172pint
pinto75625752pinto
piny911838352piny
pion67235292pion
pip78051042pi_p
pipe86434432pipe
pips85837132pips
pipy115421512pipy
pirn67128372pirn
pirog83913672pirog
piscos105112592piscos
piste75824602piste
pistol83313332pistol
piston83515922piston
pistou83211842pistou
pit56471922pi_t
pita65436432pita
pith95432692pith
piton76121582piton
pits66348742pits
pity96031932pity
piu56639542pi_u
pivot106523872pivot
pix126437932pi_x
pixy166117762pixy
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
qis126934382qis_
rise45945232rise
risk85724102risk
silo46037912silo
sis37360542sis_
so28855442__so
tiro46832362tiro
tis37056642tis_
vino76128432vino
vis66747612vis_
visa76323872visa
vise75632672vise
visor82512832visor
wino75933612wino
wis66552332wis_
wise75737342wise
wish107228732wish
wisp97124072wisp
wiss75630542wiss
wist78049292wist
xis106935332xis_

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.0632836365.1
2DLD Change Limit298721980.90632971.3
3Display Results1981980.0464304.3
 (SQL Overall)1786911981.015176050.2
 
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.