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

172 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
tidally113793(None) 
bridally1446452bridally
dally95324742__dally
finally13310102finally
ideally1137792_ideally
misally121111062misally
modally1338392modally
nodally1137912nodally
tally84526862t__ally
tidal64516442tida_l_
tiddly11308782tid_dly
tidily102811392tid_ily
tonally10311372tonally
totally1039892totally
tribally1347322tribally
virally1339642virally
vitally1339672vitally
actinally1448233actinally
ally76935643___ally
anally9513503_anally
animally1368643animally
anodally1246283anodally
antically14315673antically
apically1539823apically
areally10411243areally
atonally1148633atonally
aurally10310533aurally
axially1737233axially
bally105530103__bally
banally1249223banally
basally1237963basally
bialy105119323bi_a_ly
biddably17173543biddably
billy105525363bi__lly
bipedally1743503bipedally
caudally1446463caudally
cavally1588483cavally
cecally1459393cecally
chally144314293_chally
civilly1535483civilly
clinally1347233clinally
coitally1339483coitally
daily95922333__daily
delly96023873__delly
diddley13388103diddley
diddly12389573did_dly
dilly94923783__dilly
dismally1446513dismally
distally1239553distally
dolly96125203__dolly
dually103210063_dually
ducally13257413ducally
dully94921633__dully
epically15310573epically
equally1936863equally
ethically1748693ethically
fatally1339893fatally
feudally1554823feudally
fiddly14328483fid_dly
filially1447003filially
filly114424903fi__lly
fiscally1646073fiscally
fluidally1643153fluidally
focally15188553focally
fugally1435603fugally
gally95026173__gally
giddily1335073giddily
gilly94321633gi__lly
gyrally1435583gyrally
hidable1399403hidable
hidalgo1242373hidalgo
hilly114422163hi__lly
idly85617323_id__ly
idyll9436713_idyll_
idylls10425253_idylls
illy76925333_i__lly
jurally1736953jurally
laically1338983laically
leally94012613_leally
legally1138133legally
lineally1137793lineally
locally12179723locally
loyally13126843loyally
lytically1757373lytically
medially14129323medially
mesally12119793mesally
morally12411493morally
nasally1057443nasally
navally1366473navally
nidal65217103nida_l_
ontically14311833ontically
optically1649883optically
optimally1644563optimally
orally93113593_orally
ovally12278443_ovally
pally105727123__pally
papally1437973papally
penally121111763penally
piddly13319143pid_dly
radially1239783radially
rally84725903__rally
really93315613_really
regally1159873regally
retally10413683retally
ribaldly1442813ribaldly
ridable101412493ridable
ridley10169543rid_ley
ritually1167483ritually
rivalry1354033rivalry
royally13157733royally
rurally1038293rurally
sally85129713__sally
signally1246523signally
silly84527613si__lly
sizably2136613sizably
spinally1338013spinally
spirally1348013spirally
squally1937663squally
stilly93714073sti__lly
stoically1449643stoically
talky126215683t__alky
tall47240213t__all_
talls55133433t__alls
tarnally1138273tarnally
taxably1936043taxably
telically1449853telically
telly84920823t__elly
tenably122210453tenably
thalli958913t_halli
thrall93810293thrall_
thralls10299043thralls
tical76021493tica_l_
ticals83214713tica_ls
tiddler93110003tiddler
tideway1445153tideway
tidy86822413tid___y
tightly14327613tightly
till45941203ti__ll_
tills54631703ti__lls
timely113410113ti_mely
timidly1334593timidly
tingly103815963ti_ngly
tinily94014433ti_nily
tinkly134811153ti_nkly
tinnily1047363tinnily
tinselly1144603tinselly
tipsily1236043tipsily
tiredly1136783tiredly
today96416953toda__y
tomalley1343283tomalley
tonically14311123tonically
topically1649523topically
toroidally1444063toroidally
toxically2147563toxically
treacly1237093treacly
trevally1446343trevally
trivially1545143trivially
trolly94012353t_rolly
tunably12218293tunably
twiddly15233773twid_dly
typically1946073typically
usually1066063usually
vagally1435833vagally
venally13119563venally
viably14199833vi_ably
vicarly1536463vicarly
visually1465493visually
vocally15188343vocally
wally114625093__wally
widely133311033wid_ely
willy115321913wi__lly
zonally1938003zonally

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.1561145455.1
2DLD Change Limit1340271726.76619808.9
3Display Results1721720.0602866.7
 (SQL Overall)1786911726.98225593.1
 
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.