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

147 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
navally136647(None) 
cavally1588481cavally
nasally1057441nasally
anally9513502_anally
banally1249222banally
basally1237962basally
cavalla1257882cavalla
cavalry1554962cavalry
fatally1339892fatally
naval85315832nava_l_
nodally1137912nodally
novelly1346512novelly
ovally12278442_ovally
papally1437972papally
ravelly13268352ravelly
vagally1435832vagally
ally76935643___ally
animally1368643animally
annually1145833annually
anodally1246283anodally
areally10411243areally
aurally10310533aurally
avail8313883_avail_
avails939693_avails
avidly13548783_avidly
axially1737233axially
bally105530103__bally
caecally1547703caecally
capably1639253capably
carnally1339513carnally
casually1356823casually
caudally1446463caudally
causally1356613causally
cavallas1366843cavallas
cecally1459393cecally
chally144314293_chally
civilly1535483civilly
coevally1646283coevally
dally95324743__dally
dually103210063_dually
ducally13257413ducally
equally1936863equally
evilly1236593_evilly
facially1637643facially
faunally1445433faunally
favella1336173favella
finally13310103finally
focally15188553focally
fugally1435603fugally
gally95026173__gally
gravelly15385773gravelly
gyrally1435583gyrally
hazelly2254383hazelly
ideally1137793ideally
jovially2144753jovially
jurally1736953jurally
labially1336983labially
laically1338983laically
leally94012613_leally
legally1138133legally
levelly1335843levelly
locally12179723locally
lovably15187063lovably
loyally13126843loyally
manually1347043manually
mesally12119793mesally
misally121111063misally
modally1338393modally
morally12411493morally
movably17167043movably
nacelle938153nacelle
naively1335903naively
nakedly1534403nakedly
namable11312333namable
namely113711323na_mely
napalm1047263napa_lm
napalms1144033napalms
nasal56217593nasa_l_
nasality1146653nasality
nasals63312463nasa_ls
nastily103011033nastily
natal53921493nata_l_
natality1139193natality
natantly1144293natantly
nattily103610323nattily
naturally1246523naturally
navaid1037643nava_id
navaids1134803navaids
navar83912733nava__r
navars92810573nava_rs
navel87016573nav_el_
navels95712693nav_els
navigably1843433navigably
navvy14696683nav__vy
navy107518633nav___y
nearly94813733n_early
neatly93812483n_eatly
nelly84618813n__elly
neurally1137923neurally
nival84915773niva_l_
normally1347883normally
notably12199993notably
nounally1146483nounally
novella1076213novella
novelle1058233novelle
novelty1365173novelty
orally93113593_orally
pally105727123__pally
payably17177093payably
penally121111763penally
racially1339623racially
radially1239783radially
rally84725903__rally
rascally1347733rascally
ratably121711513ratably
really93315613_really
regally1159873regally
retally10413683retally
rivalry1354033rivalry
royally13157733royally
rurally1038293rurally
salably121610743salably
sally85129713__sally
salvably1645443salvably
savable121711863savable
savagely1543343savagely
saveloy1334663saveloy
savvily1634323savvily
squally1937663squally
tally84526863__tally
tarnally1138273tarnally
taxably1936043taxably
tidally1137933tidally
tonally10311373tonally
totally1039893totally
trevally1446343trevally
uncially1339073uncially
unreally1148223unreally
usually1066063usually
valley124311603__valley
venally13119563venally
virally1339643virally
vitally1339673vitally
vocally15188343vocally
wally114625093__wally
wavily15219483wav_ily
zonally1938003zonally

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340271478.08016587.5
3Display Results1471470.0602450.0
 (SQL Overall)1786911478.29621539.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.