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

185 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
lyingly1411526(None) 
plyingly1734501plyingly
vyingly1794151vyingly
cloyingly1843832cloyingly
cryingly1735742cryingly
jingly174111932_jingly
kingly143511302_kingly
lingy96925142l_ing_y
livingly1535632livingly
longly10279602l_ongly
losingly1236392losingly
lovingly1535702lovingly
luringly1237322luringly
lying95717452lying__
lyings10488502lying_s
pryingly1735542pryingly
shingly143210812shingly
singly104015852_singly
tingly103815982_tingly
tryingly1535882tryingly
achingly1736623achingly
alpinely1344343alpinely
atingle848253atingle
bigly114814753_bi_gly
bitingly1437393bitingly
blazingly2444483blazingly
blindly1335743blindly
bodingly1536383bodingly
boringly1438403boringly
bowingly1735793bowingly
bulgingly1644433bulgingly
calmingly1745623calmingly
clingy12659063cling_y
cooingly1436353cooingly
cringle103010353cringle
crinkly16387523crinkly
dangly114212273_dangly
daringly1348573daringly
denyingly1744643denyingly
dingey114914053_dingey
dinghy14476963_dinghy
dingily1238103_dingily
dingle84317073_dingle
dingy105721263_ding_y
dinkly144311083_dinkly
dotingly1337343dotingly
dying105316033dying__
dyings11478133dying_s
envyingly1943123envyingly
erringly1237773erringly
eying96117923eying__
faintly1337083faintly
finely123011563_finely
flamingly1845033flamingly
flaringly1646263flaringly
flowingly1943963flowingly
flying134612153flying__
flyings14496063flying_s
fringy13309263fring_y
fumingly1735743fumingly
gainly1049323gain_ly
gallingly1435863gallingly
gangly113911593_gangly
gapingly1536183gapingly
gibingly1534793gibingly
giggly12518703_giggly
gingely12378213_gingely
glaringly1445833glaringly
glowingly1743613glowingly
gulpingly1644163gulpingly
haltingly1645703haltingly
hopingly1735653hopingly
hying126514743hying__
ingle64120433__ingle
inly75622213__in_ly
jangly174310613_jangly
japingly2135763japingly
jibingly2144433jibingly
jiggly18378713_jiggly
jingle143815223_jingle
jointly1735483jointly
jokingly2334773jokingly
joltingly2044733joltingly
jungly17407693_jungly
killingly1744843killingly
kindly14358843_kindly
lairdly1134913lairdly
laithly1335653laithly
lanely93914483l_anely
langley1147453l_angley
lankly13439623l_ankly
lastingly1337243lastingly
laying104525703laying__
leanly93811503lean_ly
leeringly1345963leeringly
liefly1266363l_iefly
likely13328133l_ikely
liltingly1345443liltingly
lily76730183l_i__ly
limpingly1794573limpingly
limply133810033l_imply
lindy96918313l_in_dy
lineny94011443l_ineny
liney87029633l_in_ey
ling57447963l_ing__
linga66820823l_ing_a
lingam95112353l_ingam
lingas75116573l_ingas
linger75226003l_inger
lingo66022113l_ing_o
lings67135773l_ing_s
lingua7509913l_ingua
lingula8428803l_ingula
linky127622383l_in_ky
linsey938993l_insey
linty87126563l_in_ty
liny78141323l_in__y
lispingly1584813lispingly
lively123310813l_ively
lollingly1345353lollingly
lonely92912473l_onely
longingly1445333longingly
loonily1037073loonily
loungy10476833loung_y
lumpingly1784663lumpingly
lurkingly1744573lurkingly
lysing104710443lysing__
mainly11411493main_ly
meltingly1546303meltingly
mingle93518783_mingle
mingy115520183_ming_y
mopingly1636013mopingly
movingly1735913movingly
musingly1436433musingly
niggly11418913_niggly
pinkly155012243_pinkly
pipingly1635703pipingly
pityingly1843953pityingly
plainly1236473plain_ly
plying124312083plying__
posingly1436933posingly
pulingly1436803pulingly
ragingly1337863ragingly
rainily10310433rainily
ravingly1537293ravingly
rovingly1536923rovingly
saintly1039343saintly
savingly1537313savingly
shingle117711283shingle
shinily13268933shinily
single74520603_single
slopingly1544593slopingly
spangly1336473spangly
spindly13257383spindly
stingily1236793stingily
stingy105213203sting_y
swingby16343893swingby
swingle113510563swingle
swingy13489873swing_y
takingly1635913takingly
tangly104413933_tangly
taxingly1935483taxingly
tellingly1345433tellingly
thinly1238673thin_ly
tingle74319073_tingle
tinily94014433_tinily
tinkly134811153_tinkly
trigly103810943tri_gly
twinkly1733913twinkly
tying96019843tying__
undyingly1744163undyingly
unkingly1637253unkingly
urgingly1336733urgingly
vainly1258503vain_ly
varyingly1944693varyingly
vexingly2244663vexingly
vying125111813vying__
wiggly14559683_wiggly
willingly1645403willingly
wingy126521033_wing_y
wooingly1534903wooingly
wriggly15324893wriggly
wrinkly17295753wrinkly
wrongly1434553wrongly
zingy186516133_zing_y

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271855.81323056.4
3Display Results1851850.0632936.5
 (SQL Overall)1786911856.28228444.9
 
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.