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

289 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
tiny7613464(None) 
liny78141331liny
piny911838361piny
tidy86822431tidy
tin36362181tin_
tine45855141tine
ting56139921ting
tinny85317651tinny
tins45251311tins
tint46758871tint
tivy1014516871tivy
tony75635151tony
twiny116012811twiny
viny106025961viny
winy107034331winy
ain37579102ain_
ains46158892ains
airy75734162airy
any68440492_any
atony87218852atony
awny105919302awny
bin56658652bin_
bind76234522bind
bine66650872bine
bins66548262bins
bint67355052bint
bony96732082bony
briny104719662briny
cine66242952cine
city95122632city
cony96537832cony
deny86027122deny
didy99121522didy
din46459472din_
dine55555342dine
ding66940962ding
dingy105721262dingy
dink97137812dink
dinky135819372dinky
dino56036762dino
dins56652052dins
dint56759062dint
fin66458042fin_
find87532612find
fine75147962fine
fink117532132fink
finny114716752finny
fino76034702fino
fins75849102fins
gin46055762gin_
gink97129532gink
ginny95314572ginny
gins55543962gins
hin67559572hin_
hind85529762hind
hinky155618752hinky
hinny115616672hinny
hins76448002hins
hint77455752hint
icy86322132_icy
in28150872_in_
inby95315662_inby
ink76433642_ink
inky115321582_inky
inly75622212_inly
inn36727442_inn
ins35945612_ins
ivy96317452_ivy
jin106443942jin_
jink156227212jink
jinn115420252jinn
jins115635022jins
jinx185516582jinx
jivy176213122jivy
kin76353982kin_
kina85632012kina
kind96128572kind
kine85643442kine
king95933672king
kink76034412kink
kinky115816392kinky
kino86233632kino
kins85747922kins
lily76730192lily
limy95727722limy
lin37967382lin_
lindy96918322lindy
line46965582line
liney87029632liney
ling57447972ling
lingy96925142lingy
link86943452link
linky127622382linky
linn46034602linn
lino46343382lino
lins47059062lins
lint416266242lint
linty87126562linty
luny77324132luny
many95731862many
meiny104015412meiny
mina65136932mina
mincy125817412mincy
mind75434392mind
mine67256182mine
mingy115520182mingy
mini65634572mini
mink106636542mink
minny104518662minny
mint66758072mint
minty106323902minty
minx137723362minx
miry96326762miry
mity95528222mity
mony96830012mony
mutiny113612682mutiny
nine45842182nine
ninny84514932ninny
nixy145714522nixy
oily77932262oily
oink85429352oink
pily96132742pily
pin57066732pin_
pina65842642pina
pine67755722pine
piney105727502piney
ping75943602ping
pink107039392pink
pinky145823402pinky
pinny105222062pinny
pins65558462pins
pint66963182pint
pipy115421522pipy
pity96031942pity
pixy166117772pixy
pony96434052pony
puny95526992puny
rainy85921082rainy
rimy96621292rimy
rin36663192rin_
rind56535612rind
rindy95717402rindy
ring56541162ring
rink87737002rink
rins46153202rins
satiny93817982satiny
shiny115122142shiny
sin36265902sin_
sine46560632sine
sing57544182sing
sinh76238052sinh
sink86640152sink
sins46755282sins
sizy164816402sizy
spiny104921302spiny
stimy105114742stimy
sting65330242sting
stingy105213202stingy
stink95122502stink
stinky134611072stinky
stint57037662stint
stony85818642stony
tain45548072tain_
tains54936322tains
taint55542282taint
tan37167582tan_
tang56138692tang
tangy94519952tangy
tank85134032tank
tans46154832tans
tansy84514942tansy
tawny114713652tawny
teeny85417882teeny
teind6213612teind
ten35856112ten_
tend56433772tend
tens45647412tens
tent46159862tent
tenty86121602tenty
they107223752they
thin76732392thin_
thine85026862thine
thing96622982thing
think125018802think
thinly1238672thinly
thins85826332thins
thy97022912t_hy
ti28448302ti__
tic56343472ti_c
tick106231232tick
tics65729642tics
tide55237392tide
tie36557542ti_e
tied55535222tied
tier44936152tier
ties45248322ties
tiff104727732tiff
tike85534492tike
tiki87620852tiki
til36350272ti_l
tile45451452tile
till45941212till
tils45739622tils
tilt46252432tilt
time66235022time
tinct76126232tinct
tinea54923162tinea
tined65434532tined
tines54848422tines
tinge64626632tinge
tingly103815982tingly
tings65329212tings
tinily94014432tinily
tinkly134811152tinkly
tints56030922tints
tip56551232ti_p
tipi69924442tipi
tippy125411792tippy
tips66436772tips
tipsy106010502tipsy
tire46143362tire
tirl45029932tirl
tiro46832372tiro
tis37056652ti_s
tit36771062ti_t
titi47130632titi
tits46145052tits
titty85316652titty
tizzy16548892tizzy
toby96322292toby
tody86327222tody
ton310265102ton_
tone46953742tone
toney86027412toney
tong56434362tong
tons46553052tons
tory75840542tory
towny116114492towny
towy105325472towy
toy69655192t_oy
tray77632592tray
trey77228792trey
trine54734602trine
troy77429682troy
try66529672t_ry
tun35845192tun_
tuna45127842tuna
tune45635862tune
tung55328172tung
tunny86515032tunny
tuns45138662tuns
twin76023082twin_
twine85822362twine
twins85118982twins
tyin76424002tyin_
tying96019842tying
tyiyn11635332tyiyn
tyne76325052tyne
typy126013042typy
veiny115414362veiny
vina76331812vina
vine75643692vine
vino76128442vino
vinyl115311622vinyl
wany106432362wany
whiny144915572whiny
wily106428822wily
win66456302win_
wind85533862wind
windy126118112windy
wine74953432wine
winey115325432winey
wing86339232wing
wingy126521032wingy
wink116435032wink
wino75933622wino
wins75949182wins
wiry106422842wiry
yin67648742yin_
yins75335132yins
zany167316992zany
zin125643782zin_
zinc156819102zinc
zincy195413512zincy
zine137036162zine
zing145728622zing
zingy186516132zingy
zinky215314812zinky
zins135735012zins

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.266671770.7
2DLD Change Limit298722890.95331345.2
3Display Results2892890.0763802.6
 (SQL Overall)1786912891.295137985.3
 
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.