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

157 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
linty8712656(None) 
flinty126112491flinty
glinty106910691glinty
lindy96918311lindy
liney87029631liney
lingy96925141lingy
linky127622381linky
lint416266231lint_
lints57137191lints
liny78141321lin_y
minty106323901minty
aunty85919812aunty
banty106624002banty
bint67355042bint_
bints76130182bints
bitty106119172bitty
blintz1788842blintz
canty105226802canty
city95122622ci_ty
clingy12659062clingy
dainty105311472dainty
dicty115116292dicty
dingy105721262dingy
dinky135819372dinky
dint56759052dint_
dints67431312dints
dirty95617802dirty
ditty95019292ditty
elint55436472elint_
elints65816422elints
fifty145211422fifty
finny114716752finny
flint87333502flint_
flints95617452flints
flirty12499142flirty
ginny95314572ginny
glint66830182glint_
glints75714212glints
hinky155618752hinky
hinny115616672hinny
hint77455742hint_
hints87330622hints
inby95315662_inby
inky115321582_inky
inly75622212_inly
inti46626082_inti
into45026152_into
janty156816962janty
kilty125213892kilty
kinky115816382kinky
kitty124614562kitty
laity85318902laity
lanky125517482lanky
lefty115613562lefty
lenity9612712lenity
lent46360532lent_
lento57223392lento
lift76942722lift_
lifts85719062lifts
lilt46349942lilt_
lilts55822802lilts
lily76730182li_ly
limby125714072limby
limey104721042limey
limy95727712li_my
lin37967372lin__
linac7315412linac
line46965572lin_e
lined64934642lined
linen55728722linen
lineny94011442lineny
liner55938922liner
lines57054572lines
ling57447962lin_g
linga66820822linga
lingo66022112lingo
lings67135772lings
linin58025522linin
link86943442lin_k
links96430192links
linn46034592lin_n
linns56123332linns
lino46343372lin_o
linos55631502linos
lins47059052lin_s
linsey938992linsey
linted74021822linted
lintel64013992lintel
linter64625342linter
lintol6369472lintol
linum7313822linum
lippy124511902lippy
list47055342list_
lists56628692lists
lit39377312li_t_
lite47054542li_te
lits46252492li_ts
litu47631562li_tu
lofty115813302lofty
lunt46148842lunt_
lunts55826902lunts
luny77324132lun_y
lusty85417572lusty
milty104720072milty
mincy125817412mincy
mingy115520182mingy
minny104518662minny
mint66758062mint_
mints76834042mints
misty106120452misty
mity95528212mi_ty
nifty115211632nifty
ninety9510962ninety
ninny84514932ninny
ninth8314582ninth
nitty85418312nitty
painty114714752painty
panty105929302panty
piety105817302piety
piney105727502piney
pinky145823402pinky
pinny105222062pinny
pint66963172pint_
pinta75727052pinta
pinto75625752pinto
pints75936222pints
piny911838352pin_y
pity96031932pi_ty
plenty11311412plenty
plinth11310452plinth
pointy114913282pointy
punty106021612punty
rindy95717392rindy
runty86119042runty
silty84721632silty
sixty154912732sixty
slanty95114842slanty
slinky13399102slinky
slitty9329162slitty
tenty86121602tenty
tinny85317652tinny
tint46758862tint_
tints56030922tints
tiny76134632tin_y
titty85316652titty
unity84918492unity
viny106025952vin_y
wifty144212092wifty
windy126118102windy
winey115325432winey
wingy126521032wingy
wintry12498922wintry
winy107034322win_y
witty114717012witty
zincy195413512zincy
zingy186516132zingy
zinky215314812zinky

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.0931921408.6
2DLD Change Limit538001571.45337026.8
3Display Results1571570.0463413.0
 (SQL Overall)1786911571.592112243.1
 
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.