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

243 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
pirn6712837(None) 
airn46433831airn
firn76927501firn
girn56026861girn
kirn87123441kirn
pian66136091pian
pin57066721pi_n
pion67235291pion
pirns76020091pirns
porn65636021porn
ain37579092ai_n
air38058392air_
airns55521032airns
airs46447422airs
airt45757782airt
airy75734152airy
apian75018332apian
bairn77515532bairn
barn66444642barn
bin56658642bi_n
bird76128322bird
birk106326862birk
birl65830472birl
biro66131212biro
birr66022362birr
born67338412born
brin67038192brin
burn65636432burn
cairn75717512cairn
carn66245432carn
cion613330912cion
cire65836372cire
corn69945812corn
curn66731892curn
darn56434622darn
din46459462di_n
dire56644142dire
dirk96326832dirk
dirl57430022dirl
dirt55550382dirt
durn56127632durn
earn46737552earn
ern35738362_ern
fern76129322fern
fin66458032fi_n
fir66744892fir_
fire76245592fire
firm96026452firm
firns86018542firns
firs76637712firs
gien56330022gien
gin46055752gi_n
gird65424992gird
girl56226552girl
girns64516802girns
giro55828632giro
giron66118992giron
girt56646422girt
grin55733722grin
hern76134892hern
hin67559562hi_n
hire75538962hire
hisn79620932hisn
horn76735612horn
in28150862_i_n
inn36727432_inn
ion36051022_ion
ire36943172_ire
irk76426362_irk
iron46728462_iron
jin106443932ji_n
jinn115420242jinn
karn86129412karn
kern85326212kern
kiln85620982kiln
kin76353972ki_n
kir76535682kir_
kirk76221572kirk
kirns95315452kirns
kirs85831742kirs
lien45339802lien
limn66527692limn
lin37967372li_n
linn46034592linn
lion46334442lion
lira46928682lira
lire47845292lire
liri45128252liri
lorn46435252lorn
mien65028362mien
mir57046772mir_
mire66748232mire
miri66730372miri
mirin75023152mirin
mirk106729502mirk
mirs66940572mirs
miry96326752miry
morn66237562morn
pain65647242pain
pair66031512pair_
pairs75325832pairs
pan58466452p_an
par57467022par_
para65242172para
pard76441322pard
pare66760842pare
park105237492park
parr65731152parr
pars67560792pars
part65967462part
pawn94625302pawn
pean66147172pean
peen65938082peen
pein65834942pein
pen56558842p_en
peon65635242peon
per56353092per_
pere66450262pere
peri65636972peri
perk106232842perk
perm85834632perm
perp89029892perp
pert66759322pert
perv97224812perv
phon95925382phon
pi48145362pi__
pia56848032pi_a
pial65636702pial
piano76118712piano
pians75126962pians
pias66542552pias
pic76046822pi_c
pica85831492pica
pice84641092pice
pick125933812pick
pics85633912pics
pie55457402pi_e
pied75035362pied
pier66035292pier
piers75926332piers
pies66949602pies
pig65744972pi_g
pigs76634222pigs
piing85218832piing
pika106322952pika
pike106335212pike
piki106520562piki
pile65649692pile
pili66130352pili
pill65339462pill
pily96132732pily
pima85428652pima
pimp106024902pimp
pina65842632pina
pine67755712pine
ping75943592ping
pink107039382pink
pinna75320182pinna
pinny105222062pinny
pinon76024532pinon
pins65558452pins
pint66963172pint
piny911838352piny
pions75826392pions
pip78051042pi_p
pipe86434432pipe
pips85837132pips
pipy115421512pipy
pirana8713262pirana
pirog83913672pirog
pis56362032pi_s
pish96127912pish
piso66727562piso
piss65033332piss
pit56471922pi_t
pita65436432pita
pith95432692pith
piton76121582piton
pits66348742pits
pity96031932pity
piu56639542pi_u
pix126437932pi_x
pixy166117762pixy
plan65833942plan
poon67341262poon
pore66451262pore
pork106929682pork
porno75120652porno
porns75527342porns
porny106020192porny
port66059632port
prig75924872prig
prim85132202prim
prink114719672prink
print74837462print
prion75119992prion
pro55837262p_ro
pry85728052p_ry
pun58846512p_un
pur56840552pur_
pure65543332pure
puri65931442puri
purin75527592purin
purl65631422purl
purr64925812purr
purs65641042purs
pyin96823232pyin
pyran10514472pyran
pyre94925552pyre
pyro96019392pyro
rin36663182ri_n
sign55523052sign
sin36265892si_n
sir35746672sir_
sire46150412sire
siren54525822siren
sirs44338332sirs
sorn46641062sorn
spin66231302spi_n
spire75828692spire
spirt75032952spirt
spiry105017352spiry
spurn74815452spurn
tarn46842722tarn
tern46134802tern
tin36362172ti_n
tire46143352tire
tirl45029922tirl
tiro46832362tiro
torn46044252torn
turn46330392turn
urn35731472_urn
virl76224472virl
warn75239322warn
win66456292wi_n
wire75839812wire
wiry106422832wiry
worn75631752worn
yarn75230042yarn
yin67648732yi_n
yird87018982yird
yirr76513572yirr
zin125643772zi_n

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.280638182.1
2DLD Change Limit298722430.87334217.6
3Display Results2432430.0633857.1
 (SQL Overall)1786912431.216146949.8
 
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.