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

158 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
varmints133564(None) 
varments1339061varments
varmint12311681varmint_
armings103811502_armings
aroints7313132_aroints
carmines123617872carmines
catmints1236662catmints
farmings14298222farmings
garments1139962garments
harmines132715142harmines
harmins123716722harmin_s
sarments10311962sarments
variants1139202variants
varment12313242varment_
admits9411413_admi_ts
alarmists1145943alarmists
aments85219803_a_ments
amines84727983_a_mines
amins75534323_a_min_s
ammines11312673_ammines
anoints7311063_anoints
argents84014853_argents
armets84918353_arm_ets
armies85123693_armi_es
arming94719803_armin_g
armlets94610063_armlets
armpits1157133_armpits
aroint6328153_aroint_
aroynts1036633_aroynts
arpents93613083_arpents
arsines73518823_arsines
artists74215593_artists
averments1449093averments
barmiest125212783barmiest
calamints1348053calamints
carbines123617543carbines
cardings123812643cardings
carinas93622413car_inas
carlines103521663carlines
carlings114015863carlings
carlins93921923carlin_s
carmine112918483carmin_e
carpings133812393carpings
carvings143810213carvings
catmint11314463catmint_
darings93713653dar_ings
darlings103710383darlings
darnings10378553darnings
dormins10311273dormin_s
earings84517713ear_ings
earnings9419333earnings
earrings9299633earrings
ermines9416673_ermines
faints94818783fa__ints
famines123216263fa_mines
farinas103215243far_inas
farming133515083farmin_g
ferments13311473ferments
forints10411833for_ints
formants13269953formants
framings14338133framings
gamines103618463ga_mines
gamings114610913ga_mings
gamins94420053ga_min_s
garment10315233garment_
haemins122811403haemin_s
haints94417583ha__ints
harmin113117393harmin__
harmine122816193harmin_e
harming133717933harmin_g
harpings14379773harpings
harpins123615703harpin_s
harpists1338103harpists
hermits12312143hermi_ts
jarinas143712193jar_inas
jasmines1736623jasmines
jasmins1637083jasmin_s
kartings13418523kartings
laments94314853la_ments
laminas93615873la_minas
lariats7615053lar_iats
margents11410133margents
margins103815193margin_s
marinas93519393mar_inas
marines93928023mar_ines
markings153410243markings
marlines103818733marlines
marlings113713503marlings
marlins93420483marlin_s
marmite112413993marmi_te
marmites122212793marmites
marmots11311513marm_ots
martinets1138883martinets
martinis103311613martinis
martins93322063martin_s
mints76834043___mints
narcists1078113narcists
overmines14312683overmines
paints85921833pa__ints
palmists12268813palmists
paraments13511553paraments
parents93418123par_ents
pargings123410163pargings
parings104219213par_ings
parkings153610683parkings
partings113513733partings
payments1536943payments
permits11314003permi_ts
pharmings17254723pharmings
prints84320103_pr_ints
raiments1039903raiments
remints95117293_remints
saimins9312113saimin_s
saints65122423sa__ints
sarcinas1039283sarcinas
sardines92815573sardines
sarins63932623sar_in_s
sarment9318763sarment_
sarmenta1047723sarmenta
spearmints1443003spearmints
sprints94113773spr_ints
taints64520533ta__ints
terminus1037393terminus
torments10310453torments
vaccinas1544973vaccinas
vaccines1536503vaccines
vaginas11298813va_ginas
vagrants1246143vagrants
vahines133410523va_hines
valiants1137793valiants
valines104520213va_lines
variant10316803variant_
varias95019903var_i_as
variate101316433var_iate
variates111214983var_iates
varices123313573var_ices
variers103712663var_iers
varies94330873var_i_es
variety1337743var_iety
various103113103var_ious
varlets10411573var_lets
varnas94212823var__nas
varsity1356673varsi_ty
varying1429723varyin_g
vaunts95212623va__unts
verdicts1446013verdicts
verdins112812333verdin_s
verists103613673ver_ists
vermin113414523vermin__
verminous1445573verminous
vermis114214963vermi__s
versants1137783versants
versines112213823versines
virgins1137863virgin_s
vomits112610923v_omi_ts
warming133515083warmin_g
warnings12358453warnings
warrants1168503warrants

Search took 8 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 Limit1461621586.97020970.2
3Display Results1581580.0632507.9
 (SQL Overall)1786911587.45623966.1
 
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.