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 “vincula” 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.

99 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
vincula124639(None) 
cingula10327172cingula
incult82414772_incult
inocula947262_inocula
lingula8428802lingula
pinnula934912pinnula
vascula1245852vascula
vicuna11115902vi_cuna
vinca105315162vinc__a
vinculum1542762vinculum
acicula11228133acicula
avicular13237273avi_cular
avuncular1443313avuncular
bacula103112673_bacula
binocular1394603binocular
cannula937433cannula
canula8312963can_ula
cicala10310053ci_cala
cingular11256973cingular
circular1247903circular
facula112912233_facula
fecula113310053_fecula
fibula11258053fi_bula
finca104714503finc__a
fistula1045503fistula
furcula1245793furcula
incubi1035113_incubi
incudal1045863_incudal
incur72212253_incu_r
incurs83012283_incurs
incus73315053_incu_s
incuse83513573_incuse
indult73614033_indult
ingulf10310353_ingulf
insculp1143793_insculp
insular7138703_insular
insult62813673_insult
ligula7359673li_gula
lingua7509913lingu_a
lingual8379083lingual
lingulae9357033lingulae
lingular9407503lingular
lunula636173lun_ula
macula103013673_macula
midcult1246303midcult
noncola948293noncola
oscula837293_oscula
piacular1246573piacular
picul95015363pi_cul_
piculs103511753pi_culs
pinnulae1044183pinnulae
pinnular1044433pinnular
pinnule936003pinnule
ranula6311813ran_ula
silicula1065393silicula
sinful938803sinful_
singular9327563singular
specula11187413specula
spicula11259293spicula
spinula9257903spin_ula
tenacula1044493tenacula
tincal83913363tincal_
tincals93610643tincals
tinful938043tinful_
tinfuls1036593tinfuls
ungula737603_ungula
vacua10510463v_acu_a
valvula1343253valvula
vanilla10238743vanilla
vascular1346293vascular
veinule1056243vein_ule
venular1037683ven_ular
venule94411763ven_ule
vesicula1345223vesicula
vibracula1652613vibracula
victual1246253victual
vicugna1342083vi_cugna
vicunas1285613vi_cunas
villa85321233vi__lla
vina76331803vin___a
vinal85725813vin_al_
vinals94716483vin_als
vincas113912453vinc_as
vincible1544753vincible
vincibly1843583vincibly
vinculums1642073vinculums
vineal94814743vineal_
vinous93914173vinou_s
vinously1445283vinously
vinyl115311623vin_yl_
vinyls12467003vin_yls
viola85915543vi__ola
virgule1144283virgule
virtual1045913virtual
viscera1235083viscera
viscus11428503viscu_s
visual938803vi_sual
vizsla1833703vi_zsla
zonula1537223zon_ula

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.1561145455.1
2DLD Change Limit134027995.84322938.0
3Display Results99990.0303300.0
 (SQL Overall)178691996.02929638.6
 
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.