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

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

91 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
vibrions134509(None) 
vibrion1245251vibrion_
vibrios1235801vibrio_s
virions1039871vi_rions
fibrins1238632fibri_ns
fibroins1346212fibroins
vibrations15157372vibrations
vibrio1136222vibrio__
vibrioid1444402vibrioid
vibrionic1643262vibrionic
vibrioses1443922vibrioses
vibriosis1443922vibriosis
virion9310682vi_rion_
visions10311022vi_sions
vitriols1145052vitriols
aiblins9311473aibli_ns
aviations12311553aviations
bicrons113410473bicr_ons
billions102211793billions
brins75533973__bri_ns
briony1149043__briony
brios74725723__brio_s
carrions10312453carrions
chorions13310663chorions
citrins92614363citri_ns
citrons92913223citr_ons
clarions10310493clarions
dictions111812673dictions
diurons838823diur_ons
durions839963_durions
embryons1574043embryons
evictions14228623evictions
fibrils1236843fibri_ls
fibrin1138533fibri_n_
fibrinous1443843fibrinous
fibroids1445843fibroids
fibroin1246473fibroin_
fibrous1237593fibr_ous
fictions132410743fictions
fissions1138033fissions
gabions102410053gab_ions
gibbons1234983gib_bons
gibsons1045043gib_sons
girons75014373gi_r_ons
inions64417003_i_nions
irons55324133_i_r_ons
jillions15178283jillions
libations112510443libations
librations12149063librations
ligroins946823ligroins
microns113814783micr_ons
midirons1145883midirons
mikrons13428413mikr_ons
millions101712433millions
minions93314623mi_nions
mirins83918903mi_ri_ns
missions10311903missions
morions94014643_morions
morrions1077673morrions
pillions101610923pillions
pinions93413603pi_nions
prions84317783__prions
ribbons1136253rib_bons
turions7311573_turions
various103113103v_arious
versions11310353versions
vibists1256483vib_ists
vibrant12410393vibr_ant
vibrants1345913vibrants
vibrates132210613vibrates
vibration14138203vibration_
vibrators14237253vibrators
vibratos13217483vibratos
vibrissa1362223vibrissa
vibronic1545133vibr_onic
vicarious1445583vicarious
vicious1239493vi_cious
vidicons1443863vidicons
violins10311453violi_ns
vireos94212453vi_reo_s
virgins1137863vi_rgins
viroids1137923vi_roids
vision9311313vi_sion_
vitrains1138283vitrains
vitreous1145843vitreous
vitrics12198553vitri_cs
vitrine102511363vitri_ne
vitrines112610913vitrines
vitriol1045693vitrio_l
zillions17168073zillions
zircons1854963zi_rcons

Search took 7 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 Filter1786911461620.423422437.4
2DLD Change Limit146162916.09323988.5
3Display Results91910.0303033.3
 (SQL Overall)178691916.54627297.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.