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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

160 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
varsity135667(None) 
falsity1335912falsity
parity114719872par_ity
rarity93615492rar_ity
sparsity1345462sparsity
vacuity1545762vacuity
vanity12311932va_nity
variety1337742variety
vastity1336202vastity
vasty116215922va_s_ty
verity123714852ver_ity
versify1636332versify
acuity1139373_acuity
adversity1643813adversity
amity10416093_a_mity
aridity11510113_aridity
arista6415293_arista
aristo6414033_aristo
arsine64021043_arsine
arsino64113513_arsino
arsis55722423_arsi_s
artily92814713_artily
arty77531313_ar__ty
avidity1436483avidity
barista9310823barista
barite84224813bar_ite
basify1437513ba_sify
cariosity1446213cariosity
carnify1555883carnify
carroty1248943carroty
carsick1536343carsick
casita82913703ca_sita
cavity14310013ca_vity
charity15311023char_ity
christy1536623christy
clarity12310913clar_ity
dacoity1366183dacoity
dakoity1543423dakoity
density1137593density
diversity1645223diversity
easily9313023ea_sily
falsify1643613falsify
farside1138603farside
fatuity1336043fatuity
ferity122813343fer_ity
fruity12429703_fruity
furmity1535193furmity
gargety12388043gargety
gaseity1135113gaseity
gasify1336333ga_sify
gassily1137813gassily
gravity1437183gravity
hardily143310273hardily
harshly1636273harshly
hasty115718763ha_s_ty
horsily1338843horsily
jarosite1548383jarosite
karst97228993kars_t_
karstic1357983karstic
karsts106012943kars_ts
laity85318903la__ity
lanosity1146353lanosity
laxity1637273la_xity
marlite92917083marlite
marmite112413993marmite
marshy14558333mars_hy
morosity1347293morosity
nasty85717283na_s_ty
obesity1275653obesity
orality101111683orality
ovality1377593ova_lity
parasite10314843parasite
parroty1247863parroty
parsing103819553parsing
parsley1247803parsley
partita9310863partita
partite9317133partite
party106630613par__ty
pasty105725053pa_s_ty
paucity1435823paucity
piosity1268653piosity
porosity1348593porosity
purity114114913pur_ity
pursily1238213pursily
rabbity14266303rabbity
raisiny10319923raisiny
ramosity1345893ramosity
rarify123210063rar_ify
raucity1235853raucity
sacristy1345103sacristy
salsify1334703salsify
sanity9316203sa_nity
sassily1038723sassily
scarcity1545093scarcity
serosity1148793serosity
tardily11269583tardily
tarsi55222173tarsi__
tarsia65514273tarsi_a
tarsias74013373tarsias
tarsier74119253tarsier
tartily103511573tartily
tarty86328183tar__ty
tasty84820313ta_s_ty
tensity1039103tensity
torosity1147243torosity
vagility1546323vagility
validity1545993validity
vapidity1745193vapidity
varia85824203var_i_a
varias95019903var_ias
variate101316433variate
varicosity1853083varicosity
varied104817863var_ied
varier94619353var_ier
varies94330873var_ies
varistor1146393varistor
varix154313513var_i_x
varlet9423503varlet_
varletry1443453varletry
varlets10411573varlets
varmint12311683varmint
varmints1335643varmints
varnish13169533varnish
varnishy17163403varnishy
vars75742073vars___
varsities1239243varsities
vary105226063var___y
varying1429723varying
vast75045123va_s_t_
vastly12508723va_stly
vasts86423773va_s_ts
vaulty12388443va_ulty
vaunty12409063va_unty
venosity1446023venosity
veracity1647553veracity
verbify1834993verbify
verbosity1744063verbosity
verify153110163ver_ify
verily122616053ver_ily
verist93823893verist_
verists103613673verists
verite94323443ver_ite
verset94327323verset_
versets103913103versets
versine102515173versine
versing112314193versing
version10310923version
verst84429373vers_t_
verste94515633vers_te
versts93914733vers_ts
viduity1445353viduity
vinosity1445743vinosity
viridity1545913viridity
virility1447743virility
visit8320963v_isit_
visits9311423v_isits
voracity1645533voracity
warily122915093war_ily
warty119323823war__ty
wristy12509703_wristy

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 Limit1340271606.28021341.9
3Display Results1601600.0632539.7
 (SQL Overall)1786911606.74926476.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.