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

151 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
nettlier86481(None) 
nettier74211811nett_ier
nettler7349501nettl_er
featlier1136452featlier
jettier14358692jett_ier
nattier73614622natt_ier
nearlier836792nearlier
nestler73510452nestl_er
netter63722022nett__er
nettle64514582nettl_e_
nettled8339942nettl_ed
nettlers8307512nettl_ers
nettles73214082nettl_es
nettliest945412nettliest
nettling957212nettling
nittier73512242nitt_ier
nuttier73112022nutt_ier
pettier94213612pett_ier
settler73410652settl_er
atelier7311623_atelier
auntlier834903auntlier
battier93515713batt_ier
battler94113383battl_er
beastlier1144203beastlier
beetler938043beetl_er
belier84423563be__lier
better84723703bett__er
bittier94211663bitt_ier
bottler94211883bottl_er
cattier93317073catt_ier
costlier1038523costlier
cottier93814173cott_ier
deadlier1036863deadlier
destrier9311823destrier
detailer9268673detailer
dottier83910923dott_ier
earlier72612743_earlier
eelier64216463_e_elier
entailer877833entailer
fattier103513463fatt_ier
fetter94120383fett__er
fetterer11207813fetterer
fettle93713123fettl_e_
fettled11378933fettl_ed
fettles103912733fettl_es
fettling1266773fettling
frettier1156593frett_ier
gentler8378953gentl_er
getter74117613gett__er
gnattier934263gnatt_ier
guttier83911103gutt_ier
guttler8369163guttl_er
heathier1438343heathier
heftier1337203heft_ier
hotelier1137633hotelier
jetliner1534853je_tliner
jettied15366973jett_ied
jetties143613123jett_ies
kettle104311613kettl_e_
kettles113411613kettl_es
kittler11338163kittl_er
knottier12203983knott_ier
letter63722583lett__er
letterer8259223letterer
littler7348553littl_er
mealier93015903me_alier
measlier1036013measlier
meatier93214613meat_ier
metier83517693me_t_ier
mettle83815723mettl_e_
mettled103510543mettl_ed
mettles94115023mettl_es
motlier92010583_motlier
mottler94410343mottl_er
nastier74115293nast_ier
natter64420743natt__er
neater64424313neat__er
nebulizer2043263nebulizer
needier84010623ne_edier
needler8388893needl_er
neither1037573neit_her
nellie63614813ne_llie_
nellies73418723ne_llies
nerdier83110353ne_rdier
nervier10298833ne_rvier
nester64124183nest__er
nestle63013953nestl_e_
nestled8349913nestl_ed
nestlers8359233nestl_ers
nestles73015463nestl_es
nestlike1236083nestlike
nestling958893nestling
nether94014163ne_t_her
netlike11308913ne_tlike
netted74118713nett__ed
netters73618583nett__ers
nettiest83112433nett_iest
netting84018763nett_ing
nettly9459453nettl__y
neuter63713793neut__er
newsier10147223ne_wsier
niftier10328713nift_ier
nigglier1044843nigglier
notifier1137423notifier
nubblier1254413nubblier
nutsier7329253n_utsier
nutter63918053nutt__er
outlier72216143_outlier
pearlier1037323pearlier
peatier94017233peat_ier
pebblier1453263pebblier
pedalier1137603pedalier
pestier94317403pest_ier
petter83924773pett__er
pettle84116053pettl_e_
pettled103611513pettl_ed
pettles93916483pettl_es
pettling1168213pettling
portlier1038373portlier
pottier93516493pott_ier
prettier1069043prett_ier
puttier93314503putt_ier
rattier74015593ratt_ier
rattler74012743rattl_er
relier65826183re__lier
rentier73618223rent_ier
replier94214973re_plier
retailer82911573retailer
ruttier73412283rutt_ier
seemlier1035193seemlier
setter64023723sett__er
settle63915663settl_e_
settled83210873settl_ed
settlers8289023settl_ers
settles73916003settl_es
settling978943settling
settlor7314733settl_or
snottier8217383snott_ier
steelier839193steelier
tattier74216243tatt_ier
tattler73112213tattl_er
tentier73815923tent_ier
testier74015643test_ier
tetchier1336453tetchier
tetter64322453tett__er
vealier102712173ve_alier
vetter93417643vett__er
weaklier1534263weaklier
wetter93919443wett__er
wittier103910823witt_ier
zestier163010223zest_ier

Search took 9 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.530337152.8
2DLD Change Limit1461621517.62619166.3
3Display Results1511510.0602516.7
 (SQL Overall)1786911518.21621749.1
 
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.