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

139 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
innerly103713(None) 
angerly1137772angerly
gingerly13315302gingerly
inanely1037942inane_ly
inertly1038542i_nertly
inner54920632inner__
inners63919352inner_s
innerve1056742innerve
interlay11310042interlay
mannerly1344982mannerly
winterly14306742winterly
anergy10156863_anergy
anneal64812293anneal_
anneals7449943anneals
bankerly1744333bankerly
bindery13459833binder_y
bitterly1335603bitterly
cannery123610013canner_y
cheerly15417603cheerly
cindery13429193cinder_y
dinner74217163dinner__
dinners83915443dinner_s
eagerly1136053eagerly
elderly1154953elderly
energy10137513_energy
ferly115517353__ferly
finely123011563fine_ly
finery124512893finer_y
gingelly13305693gingelly
gingely12378213ginge_ly
gingery12368913ginger_y
ginner73915823ginner__
ginners84314223ginner_s
gnarly104610383_gnarly
gunnery11376373gunner_y
hennery1335303henner_y
ignobly1342873ignobly
inaner62213543inaner__
inaptly1244413inaptly
ineptly1245073ineptly
inert53234373i_ner_t
inerts64517023i_nerts
infer84215033infer__
inferably1749023inferably
inferno1045603inferno
infers93615443infer_s
infirmly1643083infirmly
inhere9313713inher_e
inhered11313163inhered
inheres10315173inheres
inherit10312973inherit
injury16266143injur_y
inkberry1742163inkberry
inker94421093inker__
inkers104018833inker_s
inly75622213i_n__ly
innards837153innards
innately1145613innately
inned64118423inne__d
innersole944333innersole
innerved1246293innerved
innerves1158013innerves
insanely1146123insane_ly
insert64325253inser_t
inserts74013993inserts
intently1149823intently
inter55028493inter__
interim9912873interim
interlap1048593interlap
interlays1248083interlays
intern64016543inter_n
interne73218143interne
interns73116773interns
interplay1447163interplay
inters64328053inter_s
inverity1447963inverity
inverse10249643inverse
inversely1544983inversely
invert94120083inver_t
inverts103211953inverts
inwardly1543783inwardly
knurly13405533_knurly
lanely93914483lane_ly
limberly1544463limberly
linearly1146793linearly
lonely92912473lone_ly
loverly1346973loverly
miserly12329823miserly
nearly94813733_nearly
nelly84618813__nelly
nerdy95014703__nerdy
nervy114610863__nervy
newly114610203__newly
nicely1139493nice_ly
ninety9510963nine_ty
ninthly1344213ninthly
nitery94412173niter_y
nunnery10355303nunner_y
onery8414123_oner_y
orderly1135763orderly
ornery938463orner_y
overly122411363_overly
painterly1443313painterly
pinery115214293piner_y
pinner84521503pinner__
pinners93518603pinner_s
queerly1934233queerly
sanely93114613sane_ly
sheerly13337703sheerly
shinnery14305673shinner_y
sickerly1734033sickerly
silverly14284313silverly
sincerely1443473sincerely
sinner64320603sinner__
sinners74019023sinner_s
sisterly1146333sisterly
snarly93815003_snarly
sneery93610413sneer_y
soberly1236943soberly
spinnery13416593spinner_y
synergy1442943synergy
tannery10388663tanner_y
tenderly1245293tenderly
tindery11389363tinder_y
tinner64119963tinner__
tinners73717313tinner_s
tinnily1047363tinn_ily
tinselly1144613tinselly
underlay12147653underlay
unmerry1245023unmerry
unnerve1066653unnerve
utterly1035443utterly
venery123710663vener_y
vinery124912603viner_y
winery125014283winer_y
wingedly1644013wingedly
winner94219933winner__
winners104316913winner_s
wintery13399753winter_y

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271396.59320328.7
3Display Results1391390.0463021.7
 (SQL Overall)1786911397.04525364.2
 
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.