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 foray” with Change Limit: [1]

(Change Limit cannot be increased to the length of your word, because then every letter could be different!)
to automatically search another random word after seconds.

40 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
ay51177389(None) 
aa219179941aa
ab410674741ab
aby810238041aby
ad311975021ad
ae212590291ae
ag311067451ag
ah513868791ah
ai211288381ai
al210674041al
am411875561am
an211879071an
any68440471any
ar211379371ar
as211083061as
at212393401at
aw512563401aw
ax911057781ax
aye67151761aye
ays67050291ays
bay89661621bay
by77529211by
cay87155981cay
day76254111day
fay97454861fay
gay76856491gay
hay97358771hay
jay136242671jay
kay106745541kay
lay68865351lay
may88757611may
my78125651my
nay66952771nay
oy58950111oy
pay88461181pay
ray66361991ray
say67264761say
way96757661way
ya510251501ya
yay96948711yay

Search took 1 second 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 Filter17869111160.0503573820.0
2DLD Change Limit1116400.01669750.0
3Display Results40400.0066666.7
 (SQL Overall)178691400.0722481819.4