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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

87 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
nicknaming195211(None) 
buckraming2143113buckraming
misnaming1447423mi_snaming
necklacing1942813necklacing
nickeling1645393nick_eling
nickelling1743643nickelling
nickering1636573nick_ering
nicking143516323nick___ing
nickling15278703nick__ling
nickname1642793nicknam__e
nicknamed1842153nicknam_ed
nicknamer1752243nicknam_er
nicknamers1851973nicknamers
nicknames1742753nicknam_es
nictating1237573nic_tating
pickaxing2543103pick_axing
backdating2045714backdating
benaming1339694__benaming
bickering1837664bick_ering
bricklaying2351834bricklaying
canaling112016414__canaling
coaming123818324__c_oaming
creaming133413144__creaming
diagraming1544384diagraming
dickering1737464dick_ering
dicking153617614dick___ing
dictating1338884dic_tating
hackneying2342444hackneying
hacksawing2343264hacksawing
inarming1138344_i__narming
incaging1288674inc__aging
incanting1289904incan_ting
incarnating1445544incarnating
incasing11610604inc__asing
incensing1297664incen_sing
incenting12912064incen_ting
incoming1349864inc__oming
increasing1346324increasing
incubating1597134incubating
inflaming1546264_inflaming
insnaring1046314_insnaring
intonating1148634intonating
kickboxing25111554kickboxing
kicking133314024kick___ing
kidnaping1742354ki_dnaping
licencing1443854licen_cing
licensing1244754licen_sing
licking144118284lick___ing
misframing1846234misframing
misknowing2042824misknowing
muckraking1842904muckraking
naming93917894____naming
necking143913894neck___ing
niacinamide16101574niacinamide
niching133612434nic___hing
nicknack1542834nickna__ck
nicknacks1652634nickna_cks
nictitating1444384nictitating
nidating1039784ni__dating
nimming12358144ni___mming
nitrating10312674ni_trating
nocking143615114nock___ing
nominating1349504nominating
nucleating1346934nucleating
packaging1945164pack_aging
pickeering1943534pickeering
picketing1835684pick_eting
picking163418334pick___ing
pickling17239204pick__ling
picowaving2152234picowaving
renaming11313694__renaming
ricking143920234rick___ing
screaming14217834_screaming
sickening1635994sick_ening
sicking143720174sick___ing
sickling152910334sick__ling
sicklying1943884sick_lying
signaling1136564si_gnaling
snickering1744864snick_ering
snicking153610234snick___ing
surnaming1245144_surnaming
ticketing1635634tick_eting
ticking143218754tick___ing
tickling15309434tick__ling
ticktacking19112464ticktacking
victualing1643404victualing
wicking173414774wick___ing

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 Filter1786911614500.436409841.7
2DLD Change Limit161450879.23617480.5
3Display Results87870.0302900.0
 (SQL Overall)178691879.70218418.0
 
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.