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

230 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
dirtily113858(None) 
airily93014822air_ily
artily92814712_artily
daintily1245522daintily
dingily1238102dingily
direly10311562dir_ely
dirtied93210852dirtied
dirtier83312092dirtier
dirties83119382dirties
dirty95617802dirt__y
distil73616432distil_
distill83011322distill
distils83015802distils
dizzily1934842dizzily
dottily1147282dottily
drily95816522d_r_ily
dustily113211522dustily
mirkily16266402mirkily
mistily122612342mistily
niftily1335752niftily
tartily103511572tartily
wirily123310782wir_ily
wittily1336172wittily
aerily93017013aer_ily
airtime948063airtime
airting83616303airting
brittly12165973brittly
burlily1237713burlily
cattily123210853cattily
certify1546243certify
chirpily1843773chirpily
citify1437443ci_tify
cornily12410853cornily
curlily1238383curlily
curtly1149283curt_ly
daffily1735133daffily
daftly1335443daft_ly
daily95922333d__aily
dandily12279633dandily
darkly145411073dar_kly
darting94020663darting
dartingly1436943dartingly
dartle73714833dart_le
daylily1434983daylily
deathly14336863deathly
deftly1336533deft_ly
dentil74017883dentil_
dentils84115583dentils
derail74218813derail_
derails84216393derails
destiny113111463destiny
dewily1338343d_ewily
dicliny1337673dicliny
dictier103411863dictier
diction102313053diction
dicty115116293dict__y
dicycly1843273dicycly
diddly12389573di_ddly
dietarily1344453dietarily
dietary1158663dietary
dieting93616833dieting
dignify1543893dignify
dignity1236453dignity
dilly94923783di__lly
dimity12310473di_mity
dimly114913483di__mly
dimply14339743di_mply
dinkly144311083di_nkly
dinting93520553dinting
directly1455303directly
dirking133812603dirking
dirl57430023dir__l_
dirling93316073dirling
dirls64720503dir__ls
dirndl834253dirndl_
dirndls933893dirndls
dirt55550383dirt___
dirtbag1143023dirtbag
dirtiest93014203dirtiest
dirts66824463dirt__s
dirtying1336093dirtying
distal73615773distal_
distally1239553distally
distich13312173distich
distills9319043distills
ditsy95612563di_t_sy
dittany1135653dittany
ditties83116983ditties
ditty95019293di_t_ty
ditzy186513283di_t_zy
doily95321033d__oily
doomily1336133doomily
dopily123510463d_opily
dorty96220813dort__y
dowdily1534953dowdily
dozily19329103d_ozily
drably123511613d_rably
draftily1534413draftily
drail65020973d_rail_
drails74716953d_rails
drawly134910723d_rawly
dribbly15274953dribbly
drill64718263d_r_ill
drippily1643033drippily
drizzly19364553drizzly
drolly105411673d_rolly
drooly104911073d_rooly
drumly1235703d_rumly
dryly12538453d_r_yly
ductile1048483ductile
dumpily1566233dumpily
durably13229053durably
duskily15236743duskily
earthily1445613earthily
earthly13387383earthly
eerily92913563eer_ily
emptily1445813emptily
fattily13379463fattily
feistily1445263feistily
fertile10311733fertile
fictile1238023fictile
fierily1339023fierily
fifthly1943093fifthly
filmily1535733filmily
filthily1743663filthily
firefly1635633firefly
firmly1436663fir_mly
firstly1335643firstly
fishily1637643fishily
fitly115114973fi_t_ly
flintily1434893flintily
fortify1636523fortify
furrily1337613furrily
fustily133111373fustily
giddily1335073giddily
girly94415293gir__ly
girting93113333girting
gorily10612503gor_ily
goutily1137933goutily
grimily1336523grimily
grittily1244183grittily
guiltily1243423guiltily
gustily113010903gustily
hardily143310273hardily
hastily133010663hastily
heartily1436563heartily
heftily1635763heftily
hornily1338283hornily
horsily1338843horsily
icily101211693_i_cily
ickily1535753_ickily
irately1047683_irately
jerkily2134623jerkily
joltily1746323joltily
kinkily1335223kinkily
kirtle10309473kirt_le
licitly12276673licitly
loftily1336353loftily
lustily103611243lustily
meatily12311093meatily
merrily1238633merrily
mightily1744623mightily
milkily16216553milkily
mortify1536223mortify
murkily16287113murkily
mustily123613633mustily
nastily103011033nastily
nattily103610323nattily
nervily1336863nervily
ninthly1344213ninthly
nippily1444713nippily
nitrify1335793nitrify
nitril62511533nitril_
nitrile73011373nitrile
nitrils72810703nitrils
nuttily10308633nuttily
oilily93111723oi_lily
partly116315473part_ly
perkily1637813perkily
pertly115312553pert_ly
pettily1238173pettily
pistil83915073pistil_
pistils93314303pistils
pithily1567033pithily
portly114713403port_ly
pricily142710283pricily
privily15207623privily
pursily1238213pursily
quirkily2442593quirkily
riskily1436413riskily
ritzily1945143ritzily
roily86121113__roily
rustily103112993rustily
ruttily10338613ruttily
saltily10310543saltily
shiftily1744553shiftily
silkily14236963silkily
sillily10209783sillily
sixthly2042873sixthly
smirkily1753333smirkily
sootily101810523sootily
sorrily1039833sorrily
sportily1337733sportily
surlily10310003surlily
tardily11269583tardily
tartly96014023tart_ly
tastily103311643tastily
tattily10409993tattily
testily102910803testily
thirstily1542693thirstily
tidily102811393ti_dily
tinily94014433ti_nily
tinnily1047363tinnily
tipsily1236043tipsily
tiredly1136803tiredly
tortile7313193tortile
tritely1039003tritely
tuftily1335573tuftily
verily122616053ver_ily
virally1339653virally
virile9313433vir_ile
vitrify1645003vitrify
warily122915093war_ily
wilily123310763wi_lily
windily1437943windily
wintrily1445373wintrily
wispily1535653wispily
wordily1437853wordily
worthily1745253worthily
zestily19167563zestily

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.390458182.1
2DLD Change Limit1340272305.97022450.1
3Display Results2302300.0802875.0
 (SQL Overall)1786912306.44027747.0
 
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.