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

345 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
pints7593622(None) 
bints76130181bints
dints67431311dints
hints87330621hints
lints57137191lints
mints76834041mints
paints85921831paints
pants76536921pants
pinas75434451pinas
pines76048861pines
pings85830881pings
pinks115729381pinks
pinots85920271pinots
pins65558451pin_s
pint66963171pint_
pinta75727051pinta
pintas85021391pintas
pinto75625751pinto
pintos86021291pintos
pits66348741pi_ts
points85618531points
prints84320101prints
punts75828001punts
tints56030921tints
ains46158882ain_s
airts55626342airts
aits46355532ai_ts
ants47243472_ants
aunts55227632aunts
bents76033692bents
binds86627472binds
bines76946792bines
binits85716672binits
bins66548242bin_s
bint67355032bint_
bionts8612392bionts
bits66148152bi_ts
bitts75022592bitts
bunts75729802bunts
cants77036942cants
cents74730332cents
chints115117832chints
cines75239682cines
cists76624532cists
cunts76125122cunts
dents65031802dents
diets66026642diets
dines66449152dines
dings76331402dings
dinks105927952dinks
dinos65428062dinos
dins56652042din_s
dint56759052dint_
dirts66824462dirts
dits56450522di_ts
dunts65828412dunts
elints65816422elints
faints94818782faints
feints94813872feints
fiats85324482fiats
finds95424822finds
fines86644262fines
finis86824262finis
finks125424222finks
finos86226952finos
fins75849092fin_s
fists85527542fists
fits76043462fi_ts
flints95617452flints
fonts86124752fonts
gents65729612gents
giants74713502giants
gifts96214962gifts
gilts64924262gilts
ginks104319562ginks
gins55543952gin_s
girts65423622girts
gists66026192gists
gits55744592gi_ts
glints75714212glints
haints94417582haints
hants86335402hants
hents87330742hents
hilts86924412hilts
hinds96721472hinds
hins76447992hin_s
hint77455742hint_
hists86328372hists
hits75545132hi_ts
hunts86826172hunts
inks86926502_inks
inns46920932_inns
ins35945602_in_s
inti46626072_inti
intis55121632_intis
into45026152_into
its35538832_i_ts
jilts124717412jilts
jinks165019332jinks
jinns126013842jinns
jins115635012jin_s
joints133811452joints
kilts95122182kilts
kinas95626912kinas
kinds106221812kinds
kines95039132kines
kings105825562kings
kinks84926082kinks
kinos96626142kinos
kins85747902kin_s
kists95822112kists
kits86441762ki_ts
knits93914742knits
lifts85719062lifts
lilts55822802lilts
lines57054572lines
lings67135772lings
links96430192links
linns56123332linns
linos55631502linos
lins47059052lin_s
lint416266232lint_
linty87126562linty
lists56628692lists
lits46252492li_ts
lunts55826902lunts
milts75430712milts
minas75434112minas
minds85427122minds
mines75651952mines
minis75432982minis
minks115829272minks
mint66758042mint_
minty106323902minty
minus75223932minus
mists76633902mists
mitts75523752mitts
nines55937342nines
ninth8314582ninth
ninths936932ninths
nits45741642ni_ts
oinks94819912oinks
opines84820702opines
pacts95125802pacts
pains75138282pain_s
paint75443692paint_
painty114714752painty
panes76148692panes
pangs84628662pangs
pans65855722pan_s
pant66061252pant_
panto76129412panto
pantos85222742pantos
panty105929302panty
parts77743372parts
pasts75936502pasts
pats66460852p_ats
peats76140192peats
peins76128062pein_s
pelts76128812pelts
pends85527192pends
penes75839222penes
penis75129322penis
pens65649642pen_s
pent66559072pent_
pests75933272pests
pets66248332p_ets
phots105418492phots
phuts104613502phuts
pianos84315932pianos
pians75126962pians
pias66542552pi_as
picas94626522picas
picks135226142picks
picots104616442picots
pics85633912pi_cs
piers75926332piers
pies66949602pi_es
pieta75421752pieta
pietas84516502pietas
piety105817302piety
pignus937952pignus
pignuts1035612pignuts
pigs76634222pi_gs
pikas114218092pikas
pikes115031032pikes
pikis115116392pikis
piles74742612piles
pilis75825202pilis
pills74130972pills
pilots84018872pilots
pilus75921062pilus
pimas94725102pimas
pimps114616982pimps
pin57066722pin__
pina65842632pin_a
pinata83817212pinata
pinatas93711482pinatas
pinch125619302pinch
pine67755712pin_e
pined85935322pined
pineta85815562pineta
piney105727502piney
ping75943592pin_g
pingo87122712pingo
pingos95317672pingos
pinite8321242pinite
pinites9319532pinites
pink107039382pin_k
pinko115618252pinko
pinkos125313872pinkos
pinky145823402pinky
pinna75320182pinna
pinnas85315512pinnas
pinny105222062pinny
pinon76024532pinon
pinons86019942pinons
pinot78737292pinot
pintle83818262pintle
pintles94118722pintles
pintoes95117712pintoes
pinup9612882pinup
pinups1037412pinups
piny911838352pin_y
pions75826392pions
pious74621272pious
pipes96030142pipes
pipets105714772pipets
pipits104713062pipits
pips85837132pi_ps
pirns76020092pirns
pis56362032pi__s
pisos76021062pisos
piss65033332pi_ss
piste75824602piste
pistes85325632pistes
pit56471922pi_t_
pita65436432pi_ta
pitas77427672pitas
pith95432692pi_th
piths105817542piths
pitta75018692pitta
pittas86014522pittas
pity96031932pi_ty
pivots115111902pivots
pixes144323172pixes
plaints94012052plaints
plants84921802plants
plats75531372plats
plinks124913262plinks
plinth11310452plinth
plinths1236122plinths
plots75025672plots
poets76024442poets
poinds93511142poinds
point75338732point_
pointe84619312pointe
pointes93216752pointes
pointy114913282pointy
ponds85323402ponds
pones74547042pones
pongs85526342pongs
pons65850602pon_s
pontes83627852pontes
ports75934592ports
posts75228782posts
pots66452362p_ots
pouts75530322pouts
prats76333392prats
prinks124315382prinks
print74837462print_
punas74826752punas
pungs85422222pungs
punks114822682punks
puns66641482pun_s
punt65747202punt_
punto75121322punto
puntos85915792puntos
punty106021612punty
puts65641752p_uts
putts75719272putts
pyins105815862pyin_s
quints154316562quints
rants55935342rants
rents55935182rents
rifts85718642rifts
rinds64826142rinds
rings65029172rings
rinks94827102rinks
rins46153192rin_s
riots54922012riots
runts55927632runts
saints65122422saints
sifts84918922sifts
silts55330822silts
sines55954822sines
sings65532702sings
sinhs86719602sinhs
sinks95529182sinks
sins46755272sin_s
sinus55523852sinus
sits45050202si_ts
snits54124832snits
spines85132032spines
spinets94714812spinets
spins75327982spin_s
spinto8410662spinto
spintos939132spintos
spirts85317132spirts
spits74429552spi_ts
splints94511742splints
sprints94113772sprints
stints65119762stints
suints64617782suints
taints64520532taints
tents56434212tents
tilts55325612tilts
tincts84510802tincts
tines54848422tines
tings65329192tings
tins45251302tin_s
tint46758862tint_
tits46145032ti_ts
units54923432units
vents86125932vents
vinas85126342vinas
vines85137642vines
vinos84723072vinos
wants87932212wants
wilts85023502wilts
winds95425602winds
wines85546862wines
wings95727242wings
winks125325432winks
winos84625042winos
wins75949172win_s
wists86728522wists
wits76044872wi_ts
wonts87621542wonts
yins75335122yin_s
zincs165312932zincs
zines145232652zines
zings154620892zings
zins135735002zin_s
zits136030292zi_ts

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 Filter178691538000.0931921408.6
2DLD Change Limit538003452.61020613.0
3Display Results3453450.1861854.8
 (SQL Overall)1786913452.88961852.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.