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

143 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
nigglier104484(None) 
gigglier1154321gigglier
jigglier1754091jigglier
niggler93610291niggl_er
wigglier1354451wigglier
giggler101029882giggl_er
gogglier1153922gogglier
higgler12369802higgl_er
jiggier16377822jigg_ier
jinglier1655232jinglier
kinglier1345632kinglier
naggier9309152nagg_ier
nigger89713572nigg__er
niggle83612822niggl_e_
niggled10319202niggl_ed
nigglers10307252niggl_ers
niggles93512202niggl_es
niggliest1144932niggliest
niggling11227442niggling
piggier113510002pigg_ier
sniggler10396112sniggl_er
tinglier956402tinglier
wagglier1344322wagglier
wiggier12418862wigg_ier
wiggler123110762wiggl_er
wrigglier1462412wrigglier
animalier1145933animalier
baggier113611643bagg_ier
bigger104315063bigg__er
biggie103810933bigg_ie_
biggies113813523bigg_ies
bilgier10358533bilg_ier
boggier113711583bogg_ier
boggler113910083boggl_er
buggier113611343bugg_ier
danglier1056753danglier
digger94616083digg__er
dimplier1336673dimplier
dingier93513673ding_ier
doggier103810943dogg_ier
faggier12309843fagg_ier
foggier12349913fogg_ier
fuggier12348963fugg_ier
ganglier1047603ganglier
giggle94313513giggl_e_
giggled114010073giggl_ed
gigglers11297403giggl_ers
giggles103312933giggl_es
giggliest1234323giggliest
giggling10227043giggling
girlier8289523gi_rlier
goggler10379323goggl_er
haggler12328933haggl_er
higgle113811743higgl_e_
higgled13339073higgl_ed
higglers13297233higgl_ers
higgles123911803higgl_es
higgling14217163higgling
highflier1942283highflier
hillier103413963hi_llier
inlier63615363_i_nlier
jaggier16339183jagg_ier
janglier1656113janglier
jigger155313053jigg__er
jiggle153811993jiggl_e_
jiggled17358843jiggl_ed
jiggles164111433jiggl_es
jiggliest1854183jiggliest
jiggling18226363jiggling
jingler154311093jingl_er
joggler16398833joggl_er
juggler16418873juggl_er
junglier1644303junglier
kindlier1345763kindlier
leggier9368233legg_ier
likelier1235283likelier
lingier84113383ling_ier
livelier1136873livelier
loggier93811143logg_ier
miggle104012113miggl_e_
miggles113512033miggl_es
mightier1436383mightier
millier93716703mi_llier
mingier103815293ming_ier
mingler104213843mingl_er
muggier11288943mugg_ier
nagger84016123nagg__er
nearlier836803nearlier
nettlier864813nettlier
nibbler11379273nibbl_er
niftier10328713ni_ftier
niggers93111323nigg__ers
nigglings12213733nigglings
niggly11418913niggl__y
nigher103612753ni_g_her
nightie1179653nightie_
nighties121011383nighties
nimbler11358063nimbl_er
nippier11319833ni_ppier
nittier73512243ni_ttier
nubblier1254413nubblier
oilier64417233oi__lier
piggie103210773pigg_ie_
piggies113813483pigg_ies
pimplier1445413pimplier
puggier11309383pugg_ier
ridgier937883ridg_ier
rigger85616713rigg__er
ripplier1234463ripplier
saggier92912063sagg_ier
sicklier1457213sicklier
sightlier1344453sightlier
sillier74017593si_llier
snaggier10136303snagg_ier
snigger9328373snigg__er
sniggerer1142723sniggerer
sniggle9316833sniggl_e_
sniggled11275743sniggl_ed
snigglers11314593sniggl_ers
sniggles10307313sniggl_es
sniggling1244413sniggling
soggier93410883sogg_ier
squigglier2141593squigglier
tanglier948073tanglier
timelier1036713timelier
tingler83613343tingl_er
tinklier1255443tinklier
toggler9399193toggl_er
twiggier1333073twigg_ier
uglier748953__uglier
vuggier12296813vugg_ier
wifelier1434853wifelier
wiggle113713013wiggl_e_
wiggled13299603wiggl_ed
wigglers13257213wiggl_ers
wiggles123312463wiggl_es
wiggliest1444883wiggliest
wiggling14217293wiggling
wilier93217073wi__lier
wingier113413283wing_ier
wiselier1137363wiselier
wriggler13295263wriggl_er
zingier17369493zing_ier

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.420425454.8
2DLD Change Limit1461621436.25023385.9
3Display Results1431430.0463108.7
 (SQL Overall)1786911436.71626606.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.