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

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

90 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
vim87437031vi_m
viol76523601viol
aim57858222ai_m
atom67824522atom
avion84218342avion
axiom143913592axiom
bio57846092bio_
biog76122332biog
biome94916992biome
bios66335332bios
boom87435672boom
cion613330922cion
dim68146502di_m
diol57329142diol
dom69752442_dom
doom76430072doom
film94828182film
firm96026462firm
from96923922from
glom75424382glom
him86247672hi_m
idiom899962idiom
ion36051032_ion
ism56322392_ism
jism135514782jism
limo65529742limo
lion46334452lion
loom67035052loom
mim76048432mi_m
mom78853162_mom
nim57142962ni_m
nom510450642_nom
om48553002__om
pion67235302pion
pom78249912_pom
prom87631702prom
rim56052282ri_m
riot45947222riot
rom59855632_rom
room66235082room
sim56553152si_m
som59153812_som
tom514358052_tom
toom66532932toom
venom103914862venom
via65636252vi_a
vial76731102vial
vibe95124512vibe
vice95732862vice
vid77241822vi_d
vide85432772vide
vids85627552vids
vie65447642vi_e
vied86328642vied
vier75428162vier
vies75238632vies
view105917682view
vig75637532vi_g
viga85622972viga
vigor92612422vigor
vigs85427282vigs
vile76139812vile
vill75235082vill
vims95423322vims
vina76331812vina
vine75643692vine
vino76128442vino
vinos84723072vinos
viny106025962viny
viola85915542viola
viols86118102viols
virl76224482virl
vis66747622vi_s
visa76323882visa
vise75632682vise
visor82512832visor
vita75828532vita
viva106119102viva
vive105426632vive
vizor173010092vizor
voe67739052v_oe
void86220572void
vow96136312v_ow
vox136628152v_ox
vroom105312472vroom
vrow105817472vrow
vum85428652v_um
whom127018182whom
yom88043442_yom
zoom156722102zoom

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 Filter178691298720.560319091.1
2DLD Change Limit29872900.86034734.9
3Display Results90900.0165625.0
 (SQL Overall)178691901.436124436.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.