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

220 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
pirns7602009(None) 
airns55521031airns
firns86018541firns
girns64516801girns
kirns95315451kirns
pians75126961pians
pins65558451pi_ns
pions75826391pions
pirn67128371pirn_
porns75527341porns
ains46158882ai_ns
airn46433832airn_
airs46447422air_s
airts55626342airts
bairns86710872bairns
barns76335142barns
bins66548252bi_ns
birds85421332birds
birks114920302birks
birls74023162birls
biros75325132biros
birrs74917102birrs
brins75533972brins
burns74926782burns
cairns85313302cairns
carns75937562carns
cions75222852cions
cires74932912cires
corns76034762corns
curns74924282curns
darns66927892darns
dins56652042di_ns
dirks105619522dirks
dirls64720502dirls
dirts66824462dirts
durns64819872durns
earns55927562earns
erns45428232_erns
ferns85220082ferns
fins75849092fi_ns
fires85740752fires
firms105217422firms
firn76927502firn_
firs76637712fir_s
gins55543952gi_ns
girds74816992girds
girls64518392girls
girn56026862girn_
girons75014372girons
giros65722652giros
girts65423622girts
grins65427222grins
herns84825582herns
hins76447992hi_ns
hires86134342hires
horns86125332horns
inns46920932_inns
ins35945602_i_ns
ions46737852_ions
ires45639282_ires
iris45732552_iris
irks86220132_irks
irons55324132_irons
jinns126013842jinns
jins115635012ji_ns
karns96624142karns
kerns94719562kerns
kilns95112982kilns
kins85747912ki_ns
kirks84915262kirks
kirn87123442kirn_
kirs85831742kir_s
liens56525502liens
limns75718392limns
linns56123332linns
lins47059052li_ns
lions55923212lions
liras56021982liras
miens76118302miens
mires75640882mires
mirins83918902mirins
mirks115122142mirks
mirs66940572mir_s
morns75527442morns
pains75138282pains
pairs75325832pair_s
pans65855732p_ans
paras76143042paras
pards85634332pards
pares77164482pares
paris75145942paris
parks116134462parks
parrs75928672parrs
pars67560792par_s
parts77743372parts
pawns108818132pawns
peans75437642peans
peens76428192peens
peins76128062peins
pens65649642p_ens
peons75327182peons
peres76246642peres
peris75537072peris
perks115325802perks
perms95524512perms
perps95521482perps
pervs105117372pervs
phons105221142phons
pian66136092pian_
piano76118712piano
pianos84315932pianos
pias66542552pi_as
picas94626522picas
picks135226142picks
pics85633912pi_cs
piers75926332piers
pies66949602pi_es
pignus937952pignus
pigs76634222pi_gs
piing85218832piing
pikas114218092pikas
pikes115031032pikes
pikis115116392pikis
piles74742612piles
pilis75825202pilis
pills74130972pills
pilus75921062pilus
pimas94725102pimas
pimps114616982pimps
pin57066722pi_n_
pina65842632pi_na
pinas75434452pinas
pine67755712pi_ne
pines76048862pines
ping75943592pi_ng
pings85830882pings
pink107039382pi_nk
pinks115729382pinks
pinna75320182pinna
pinnas85315512pinnas
pinny105222062pinny
pinons86019942pinons
pint66963172pi_nt
pints75936222pints
piny911838352pi_ny
pion67235292pion_
pious74621272pious
pipes96030142pipes
pips85837132pi_ps
pirana8713262pirana
piranas9912602piranas
pirog83913672pirog
pis56362032pi__s
pisos76021062pisos
piss65033332pi_ss
pitas77427672pitas
piths105817542piths
pitons85319042pitons
pits66348742pi_ts
pixes144323172pixes
plans75731272plans
pons65850602p_ons
poons75430972poons
pores75849032pores
porks115124142porks
porn65636022porn_
porno75120652porno
pornos85015252pornos
porny106020192porny
ports75934592ports
pries74339532pries
prigs85219702prigs
prims95425932prims
prink114719672prink
prinks124315382prinks
print74837462print
prints84320102prints
prions84317782prions
priss74623892priss
pros65742782p_ros
puns66641482p_uns
purins83722652purins
puris75332022puris
purls74723352purls
purrs75320432purrs
purs65641042pur_s
pyins105815862pyins
pyrans11411062pyrans
pyres105523882pyres
pyros105718292pyros
rins46153192ri_ns
signs65516322signs
sins46755272si_ns
sirens65318152sirens
sires55945372sires
sirs44338332sir_s
sorns55028422sorns
spins75327982spi_ns
spires84628112spires
spirts85317132spirts
spurns84811382spurns
tarns56433952tarns
terns55226872terns
tins45251302ti_ns
tires55437492tires
tirls54519802tirls
tiros54524892tiros
turns55623242turns
urns46323902_urns
vires84529682vires
virls85618602virls
virus85316842virus
warns87231002warns
wins75949172wi_ns
wires86034912wires
yarns85621792yarns
yins75335122yi_ns
yirds96612512yirds
yirrs8469192yirrs
zins135735002zi_ns

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 Filter178691538000.360496363.9
2DLD Change Limit538002201.46636698.5
3Display Results2202200.0633492.1
 (SQL Overall)1786912201.88994595.6
 
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.