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

159 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
unagile83828(None) 
agile65122262__agile
fragile1147842fragile
nargile847652_nargile
unable83819222una_ble
unaging9510932unaging
unakite1138742unakite
unalike11311532unalike
unpile81914322un_pile
vagile10310542_vagile
abaxile1644083abaxile
anagoge9166643anagoge
angle64528873an_g_le
anile54634463__anile
axile126020513__axile
bangle94018953bang_le
beagle93612593beag_le
bungle97116113bun_g_le
cagily12411563_cagily
daggle93711903_daggle
dangle84119303dang_le
draggle1056103draggle
eagle64219483_eag_le
enable83318483ena_ble
enamine91214313enamine
engild8107613en_gild
engine71114863en_gine
ensile62616473en_sile
facile112514883_facile
fenagle11197153fenag_le
finagle11238313finag_le
fungible1444173fun_gible
gaggle93412623_gaggle
gracile102512603gracile
habile11515213_habile
haggle113511983_haggle
hoagie102310013hoagi_e
imagine1037883imagine
ingle64120433in_g_le
inutile739883inutile
jangle144416293jang_le
jungle144012653jun_g_le
labile8315223_labile
magilp1137613_magilp
maile75232223_ma_ile
mangily1339753mangily
mangle93921323mang_le
nail45838653_na_il_
nailed74021493_na_iled
nailer64119363_na_iler
nails55730403_na_ils
naive85116213_na_ive
narghile1244033_narghile
nargileh1272433_nargileh
nargiles976793_nargiles
narine63422553_narine
native9613013_native
niggle83612823_niggle
nubile83212713_nubile
pantile93918483pantile
pungle94413573pun_g_le
quantile1747323quantile
raggle83712883_raggle
runagate944293runagate
snaffle13216253snaffle
snaglike1335283snaglike
snail57020203sna_il_
snailed83811923sna_iled
snails64816653sna_ils
snakily1436913snakily
sniggle9316833sniggle
snuggle9275713snuggle
stabile9312063stabile
stagily1139053stagily
tangible1145603tangible
tangle74019953tang_le
tunable92511313tuna_ble
umangite1144823umangite
unadult856643unadult
unaged83916423unag_ed
unageing1036273unageing
unagreed1036823unagreed
unai44824783una_i__
unaided92414603una_ided
unaimed102812493una_imed
unaired82916013una_ired
unais53420773una_i_s
unakin10310963unaki_n
unakites1237543unakites
unallied938393unallied
unamiable1348473unamiable
unaneled939793unaneled
unaptly1244793unaptly
unawake1445343unawake
unaware1038033unaware
unbale83616403un_bale
unboiled112410373unboiled
unbridle1145393unbridle
unbuild1035723unbuild
unbuilt948003unbuilt
uncage93014873uncag__e
uncaging1268713uncaging
unciae83215313un_ciae
uncle7317053un__cle
uncoil8811853uncoil_
uncoiled112512683uncoiled
uncoils979533uncoils
undine7817263un_dine
undocile1145953undocile
uneasily1146453uneasily
unedible1146413unedible
unfoiled12249723unfoiled
ungainly1244423ungainly
ungalled1078463ungalled
ungird887973un_gird
ungirt71112713un_girt
unglue748003un_glue
ungula737603un_gula
ungulae837313un_gulae
unhailed12219963unhailed
unisize1647343unisize
unite54828383un__ite
unitive10310563unitive
unitize16310033unitize
unlike102614063un_like
unlive92712333un_live
unmailed11229763unmailed
unnail6410583unnail_
unnailed9229443unnailed
unnails738223unnails
unoiled82415483un_oiled
unpiled102312743un_piled
unpiles92112783un_piles
unripe82012093un_ripe
unsaddle1044753unsaddle
unsoiled92412083unsoiled
unspilt938853unspilt
untangle966323untangle
untie54425493un_ti_e
until53517743un_til_
untwine1038623untwine
unveil957343unveil_
unveiled1298163unveiled
unveils1045753unveils
unvoice12126153unvoice
unwarily1446363unwarily
unwhite1336813unwhite
unwise9510803un_wise
uppile10178503u_ppile
uracil8311543uracil_
uracils939373uracils
uralite71714103uralite
uranide82212093uranide
uranite72515693uranite
usable84012553usa_ble
usage6410213usag__e
utile54718933u__tile
waggle113612303_waggle
wangle103817503wang_le

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.420425454.8
2DLD Change Limit1340271597.17318684.9
3Display Results1591590.0632523.8
 (SQL Overall)1786911597.65623340.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.