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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

38 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
ulnad6561145(None) 
ulna46317321ulna_
ulnae55214561ulnae
ulnar56013981ulnar
ulnas55716531ulnas
aland65526402aland
bland85320452bland
clad76225822cl_ad
eland65820382eland
glad65624002gl_ad
gland75217702gland
gonad75216042gonad
iliad64613442iliad
lad48165702_l_ad
land56337302_land
lead56038852_lead
load56730592_load
luna46229852luna_
lunar57017302lunar
lunas55025012lunas
menad85918982menad
monad85519472monad
plead85818462plead
ulan46527392ul_an
ulans54921302ulans
ulpan7310122ulpan
ulva75412692ulva_
ulvas84511502ulvas
unai44824782u_nai
unau43924152u_nau
unlade72714142unlade
unlaid7311752unlaid
unlay84613702unlay
unlead73312362unlead
unled64021042unled
unload73010772unload
upland938852upland
upload9257772upload

Search took 2 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 Filter178691538000.0961861364.6
2DLD Change Limit53800381.75030742.9
3Display Results38380.0132923.1
 (SQL Overall)178691381.85996122.1