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

131 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
tinseling103664(None) 
tinselling1145521tinselling
dieseling1146142dieseling
hanseling1338062hanseling
hirseling1396272hirseling
tasseling1035852tasseling
teaseling1036912teaseling
tingeing10198532tinge_ing
tingling102210802tin_gling
tinkering1437692tinkering
tinkling13239232tin_kling
tunneling1034692tunneling
aneling82719503_an_eling
angeling102811733_angeling
bingeing12237643binge_ing
canceling14310163canceling
chiseling1536403chiseling
cindering13311213cindering
consoling12310873consoling
counseling1345463counseling
dieselings1252913dieselings
dindling112411163din_dling
enisling949633enis_ling
ensiling9410723_ensiling
finagling1434703finagling
finessing1345123finessing
fingering1439183fingering
fingerling1544833fingerling
firstling1334423firstling
funneling1344513funneling
gingering1238863gingering
ginseng933433ginse__ng
handseling1544323handseling
hanselling1445623hanselling
hindering14310263hindering
hireling121210993hi_reling
hirselling1444833hirselling
hirsling1277543hirs_ling
houseling1337483houseling
inbeing1038323_inbe_ing
indexing1737113_indexing
inhaling1239523_inhaling
inhering12913703_inhering
inkling122911303_in_kling
inserting10914233_inserting
insetting1079283_insetting
insouling1036823_insouling
insulin738483_insulin_
insulins848863_insulins
insulting1038053_insulting
insuring9311153_insuring
isling71213873_i_s_ling
jingling17188573jin_gling
kenneling1464083kenneling
kindling14229623kin_dling
kneeling13287783_kneeling
libeling1139873li_beling
lingering11310493lingering
mingling122010933min_gling
morseling1238073morseling
nickeling1645383nickeling
paneling111013623pan_eling
pindling122110983pin_dling
pinkening1634993pinkening
princeling1544653princeling
ridgeling12155253ridgeling
riesling939013ries_ling
rinsing82516113rins__ing
sideling101012173si_deling
sinewing1267593sin_ewing
singeing10209933singe_ing
singling101913003sin_gling
sintering101014793sintering
sniveling1336033sniveling
tangling101712533tan_gling
tasselling1145233tasselling
teaselling1145333teaselling
teazeling1934543teazeling
tendering112210803tendering
tensing84616653tens__ing
tentering102313203tentering
ticketing1635633ticketing
tickling15309433ti_ckling
tieing73518763ti__e_ing
tiering8315243ti__ering
tiling73426553ti___ling
tillering1037863tillering
tilling83522773ti__lling
timbering14117713timbering
timeline1039243ti_meline
tincting1148883tin_cting
tinging93619443tin__ging
tining74927543tin___ing
tinklings14224663tin_klings
tinning83117283tin__ning
tinsel639443tinsel___
tinseled935763tinsel_ed
tinselled1044413tinselled
tinselly1144603tinsel_ly
tinsels738373tinsel__s
tinting84620603tin__ting
tippling13196703ti_ppling
tirling83315733ti__rling
tissuing935103ti_ssuing
titling83715793ti__tling
tittering102310303tittering
tonsuring1046503tonsuring
tousling938793tous_ling
toweling122910373t_oweling
trameling1249053trameling
traveling1349053traveling
trindling1137133trin_dling
trinketing1544153trinketing
troweling1376363troweling
tunnelings1142493tunnelings
tunnelling1144383tunnelling
tussling935823t_ussling
twingeing14143373twinge_ing
twinkling1743643twin_kling
unsealing10711043_unsealing
unseeing988293_unseeing
unselling10810333_unselling
unsewing1287433_unsewing
unsexing1686853_unsexing
unsling8313643_uns_ling
viseing11299163vi_se_ing
weaseling1335613weaseling
windling132212263win_dling
winkling16298293win_kling
wintering13412353wintering
wintling12249923win_tling

Search took 10 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 Filter1786911486410.1531167915.0
2DLD Change Limit1486411319.03316455.3
3Display Results1311310.0632079.4
 (SQL Overall)1786911319.24919320.0
 
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.