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 “linguine” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

106 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
linguine93759(None) 
linguines1046511linguines
linguini945531linguini
anguine839912_anguine
linguae8398412lingu_ae
linguica1143482linguica
linguinis1044282linguinis
linguisa944472linguisa
linguist948572linguist
lingulae9357032lingulae
longline938762longline
sanguine947632sanguine
beguine1068503_beguine
bingeing12237643bingeing
binging113619383bing_ing
clinging122910913cling_ing
dinging103618613ding_ing
disguise1046833disguise
engine71114863_eng_ine
figuline1256033fi_guline
figurine1245603fi_gurine
flinging133310053fling_ing
genuine838373gen_uine
hinging123917123hing_ing
incline9314643_incline
induing91910943_induing
induline939493_induline
ingoing9311023_ingoing
inguinal945603_inguinal
inosine7314283_inosine
inquire16227993_inquire
intine61021983_in_tine
intwine1038513_intwine
jingling17188573jingling
kinging133115033king_ing
kinglike1235093kinglike
kingpin1445003kingpin_
kingpins1544903kingpins
kingside1444263kingside
lagune7158633l_agu_ne
landline9311443landline
langsyne1242823langsyne
language10105003language
langue71012183langu__e
languid936623langui_d
languish12136253languish
lanoline8311953lanoline
leaguing1035343leaguing
lifeline11167663lifeline
lignin74911193li_gnin_
lignins84010493li_gnins
lignite81310303li_gnite
ligroine945693ligroine
ligulae8308753li_gulae
ligule74010833li_gu_le
ligure7279473li_gu_re
limacine1246003limacine
limousine1143263limousine
lindane839033lin_dane
linelike12159003linelike
lingerie959203lingerie
lingering11310513lingering
lingier84113383ling_ier
lingua7509913lingu__a
lingual8379083lingu_al
linguals9317223linguals
linguicas1243063linguicas
linguisas1043573linguisas
linguists1045743linguists
lingula8428803lingu_la
lingular9407503lingular
lingulate10368193lingulate
linin58025523lin__in_
lining74526803lin__ing
linins65922143lin__ins
linking123818253lin_king
linting83820983lin_ting
longeing10177593longeing
longing93915783long_ing
longlines1047983longlines
longtime1144363longtime
longwise1244083longwise
lunging93714213lung_ing
mingling122010933mingling
misguide12145703misguide
penguin1045873penguin_
penguins1145383penguins
pinging113419553ping_ing
pinguid1146243pingui_d
ringbone1144953ringbone
ringing93521283ring_ing
ringlike1336243ringlike
ringside1045403ringside
sanguines1047183sanguines
singeing10209933singeing
singing93221423sing_ing
singling101913003singling
slinging103312863sling_ing
tingeing10198553tingeing
tinging93619463ting_ing
tingling102210823tingling
tonguing1046263tonguing
wingding1436453wingding
winging123718713wing_ing
winglike1635593winglike
zinging183513943zing_ing

Search took 7 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 Filter1786911461620.436409841.7
2DLD Change Limit1461621066.39022873.6
3Display Results1061060.0462304.3
 (SQL Overall)1786911066.87226002.8
 
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.