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 “vibrion” 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
vibrion124525(None) 
vibrio1136221vibrio_
vibrions1345091vibrions
vibrios1235801vibrios
virion9310681vi_rion
fibrin1138532fibri_n
fibroin1246472fibroin
vibration14138202vibration
vibrioid1444402vibrioid
vibrionic1643262vibrionic
virions1039872vi_rions
vision9311312vi_sion
vitriol1045692vitriol
aviation11312743aviation
bicron103710773bicr_on
billion92212173billion
brin67038193__bri_n
brio65432493__brio_
briony1149043__briony
brios74725723__brios
carrion9312673carrion
chorion12311773chorion
citrin82615413citri_n
citron83112983citr_on
clarion9311663clarion
diction102313053diction
diuron738573diur_on
durion7510963_durion
embryon1474063embryon
eviction13228683eviction
fibril1137163fibri_l
fibrils1236843fibrils
fibrins1238633fibrins
fibroid1337243fibroid
fibroins1346213fibroins
fiction122010733fiction
fission1038733fission
gabion93211033gab_ion
gibbon1135323gib_bon
gibson935123gib_son
giron66118993gi_r_on
inion54620183_i_nion
iron46728463_i_r_on
jillion14188933jillion
libation102411363libation
libration111510163libration
libri74610113libri__
ligroin848043ligroin
micron103714283micr_on
midiron1046003midiron
mikron12318503mikr_on
million91813143million
minion83416243mi_nion
mirin75023153mi_ri_n
mission9312743mission
morion86217733_morion
morrion959003morrion
pillion92011703pillion
pinion83815893pi_nion
prion75119993__prion
ribbon1036533rib_bon
turion6313163_turion
version10310923version
vibist11610583vib_ist
vibrant12410393vibrant
vibrate122811523vibrate
vibrations15157373vibrations
vibrato12247383vibrato
vibrator13227343vibrator
vibratos13217483vibratos
vibrioses1443923vibrioses
vibriosis1443923vibriosis
vibrissa1362223vibrissa
vibronic1545133vibr_onic
vidicon1343783vidicon
violin9311983violi_n
vireo84816453vi_reo_
vireos94212453vi_reos
virgin1038083vi_rgin
virid94116043vi_ri_d
virile9313433vi_rile
viroid10411523vi_roid
visions10311023vi_sions
vitrain1038943vitrain
vitric112510113vitri_c
vitrics12198553vitrics
vitrify1645003vitrify
vitrine102511363vitrine
vitriols1145053vitriols
zillion16188773zillion
zircon1754953zi_rcon

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 Filter1786911340270.406440125.6
2DLD Change Limit134027915.67323625.4
3Display Results91910.0303033.3
 (SQL Overall)178691916.10929250.5
 
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.