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

108 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
linin5802552(None) 
kinin94917321kinin
lignin74911191lignin
linen55728721linen
lining74526801lining
linins65922141linins
linn46034591lin_n
lipin75518891lipin
alanin6317272alanin
alining81917042alining
binit76431582binit
blini75519272blini_
blinis85313682blinis
clinic104312792clinic
conin76232722conin
dining84525132dining
ficin103516722ficin
fining104223212fining
finis86824262finis
inia45024692_inia
inion54620172_inion
inn36727432_in_n
jinn115420242jin_n
jinni125310632jinni
kinins104014582kinins
lain46146282l_ain
laminin939972laminin
lapin75222922lapin
layin84720332layin
lenis56326862lenis
levin84816412levin
licit74327682licit
lien45339802li_en
ligan67920282ligan
lignan75510322lignan
lignins84010492lignins
liken911818842liken
liking114319582liking
liman75921602liman
limen75426032limen
limina83514492limina
liming94021232liming
limit73126332limit
limn66527692li_mn
limnic10418832limnic
limning103710312limning
lin37967372l__in
linac7315412linac
linden7411452linden
lindy96918312lindy
line46965572lin_e
lined64934642lined
linens64818392linens
lineny94011432lineny
liner55938912liner
lines57054572lines
liney87029622liney
ling57447962lin_g
linga66820812linga
lingo66022102lingo
lings67135772lings
lingy96925132lingy
linier64423782linier
linings84313072linings
link86943442lin_k
linking123818252linking
links96430192links
linky127622382linky
linns56123332linns
lino46343372lin_o
linos55631502linos
lins47059052lin_s
lint416266232lin_t
linting83820982linting
lints57137192lints
linty87126562linty
linum7313822linum
liny78141322lin_y
lion46334442li_on
lipid85916172lipid
lipins85016882lipins
liri45128252liri_
liven85021732liven
livid96714422livid
living104318322living
login66025002login
loin46838722l_oin
lupin75215842lupin
lysin84512782lysin
mini65634542mini_
minim97321592minim
mining94225442mining
minion83416232minion
minis75432982minis
mirin75023142mirin
ninon55517382ninon
pining93726532pining
pinion83815892pinion
pinon76024532pinon
pinyin112710612pinyin
quinin152811952quinin
renin54830032renin
ricin74620212ricin
tining74927542tining
venin85118662venin
vinic10314972vinic
vining104619462vining
wining103625052wining

Search took 4 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.1701051123.5
2DLD Change Limit538001082.95618200.3
3Display Results1081080.0432511.6
 (SQL Overall)1786911083.16956387.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.