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

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

94 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
niggliest114493(None) 
giggliest1234321giggliest
jiggliest1854181jiggliest
wiggliest1444881wiggliest
goggliest1234062goggliest
jiggiest17277692jigg_iest
jingliest1735972jingliest
kingliest1436522kingliest
naggiest102610012nagg_iest
niggles93512202niggl_es_
nigglier1044842nigglie_r
piggiest12259662pigg_iest
tingliest1047682tingliest
waggliest1434782waggliest
wiggiest13269012wigg_iest
wriggliest1542932wriggliest
baggiest123011753bagg_iest
biggest1138143bigg__est
biggies113813523bigg_ies_
bilgiest11309883bilg_iest
boggiest123110933bogg_iest
buggiest123410363bugg_iest
dangliest1137173dangliest
dimpliest1436583dimpliest
dingiest102915373ding_iest
doggiest113410523dogg_iest
faggiest132910183fagg_iest
foggiest13249653fogg_iest
fuggiest13228813fugg_iest
gangliest1137673gangliest
giggles103312933giggl_es_
gigglier1154323gigglie_r
girliest93010403gi_rliest
higgles123911803higgl_es_
hilliest113914113hi_lliest
jaggiest17289323jagg_iest
jangliest1746383jangliest
jiggles164111433jiggl_es_
jigglier1754093jigglie_r
jungliest1744923jungliest
kindliest1436113kindliest
leggiest10308233legg_iest
likeliest1346123likeliest
lingiest93715263ling_iest
liveliest1247093liveliest
loggiest103011013logg_iest
miggles113512033miggl_es_
mightiest1546443mightiest
mingiest113315823ming_iest
muggiest12228533mugg_iest
nearliest949363nearliest
nettliest945413nettliest
niellist848353nielli_st
niftiest112910073ni_ftiest
niggle83612823niggl_e__
niggled10319203niggl_e_d
niggler93610293niggl_e_r
nigglers10307253niggl_ers
niggling11227443niggli_ng
nigglings12213733nigglings
nighest11310693ni_g_hest
nighties121011383nighties_
nihilist1147163nihili_st
nimblest1236923nimbl_est
nippiest12279983ni_ppiest
nittiest82712603ni_ttiest
nubbliest1354363nubbliest
oiliest72817683oi__liest
piggies113813483pigg_ies_
pimpliest1545483pimpliest
puggiest12219223pugg_iest
ridgiest1038903ridg_iest
rippliest1334783rippliest
saggiest102812723sagg_iest
sickliest1547523sickliest
sightliest1445113sightliest
silliest84017103si_lliest
snaggiest11126683snagg_iest
sniggles10307313sniggl_es_
soggiest102711643sogg_iest
squiggliest2251693squiggliest
tangliest1068423tangliest
timeliest1147233timeliest
tinkliest1336133tinkliest
twiggiest1443413twigg_iest
ugliest8410153__ugliest
vuggiest13216923vugg_iest
wifeliest1545883wifeliest
wiggles123312463wiggl_es_
wigglier1354453wigglie_r
wiliest103416593wi__liest
wingiest123214283wing_iest
wiseliest1237723wiseliest
zingiest182810893zing_iest

Search took 8 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.423422437.4
2DLD Change Limit148641947.50019818.8
3Display Results94940.0462043.5
 (SQL Overall)178691947.96922423.3
 
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.