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

167 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
variants113920(None) 
valiants1137791valiants
variant10316801variant_
harianas1139162harianas
invariants1374082invariants
lariats7615052laria_ts
parians93519732parian_s
radiants9259442radiants
vagrants1246142vagrants
valiant10314622valiant_
variance1397412variance
variances14117362variances
varias95019902varia__s
variate101316432varia_te
variates111214982variates
varments1339062varments
varmints1335642varmints
versants1137782versants
vicariants1543732vicariants
warrants1168502warrants
affiants1445233affiants
alants67722023_a_lants
amiantus1044383_amiantus
argents84014853_argents
arhats9312973_arha_ts
arias55438023_aria__s
aroints7313133_aroints
aroynts1036633_aroynts
arpents93613083_arpents
arrant6623253_arrant_
avians93711563_avian_s
banians9312033banian_s
birianis1056343birianis
brants85723053_br_ants
callants104112143callants
carats85929023car_a_ts
carcanets1347303carcanets
carinas93622403cari_nas
carinate103320243carinate
covariant1447863covariant_
currants1037933currants
damianas1155573damianas
darings93713653dari_ngs
deviants1236733deviants
durians839573durian_s
earings84517713eari_ngs
errants7410643_errants
evacuants1442953evacuants
fabricants1743023fabricants
faints94818783fa_i_nts
farinas103215233fari_nas
forints10411833fori_nts
formants13269953formants
galivants1344203galivants
gallants93310373gallants
gardant9314463gardant_
garlands1038323garlands
garments1139963garments
giants74713503__giants
grants73722473_gr_ants
guardants1143793guardants
habitants1445123habitants
haints94417583ha_i_nts
hariana10310243harian_a
haricots1347333haricots
harijans1845723harijan_s
invariant1266813invariant_
irritants944613irritants
jarinas143712183jari_nas
jurants14379213jur_ants
kalians11310183kalian_s
karats106420493kar_a_ts
lariat6629043laria_t_
magians10310753magian_s
maranta9311693mar_anta
marantas10310023mar_antas
margents11410133margents
marinas93519383mari_nas
marinate103017783marinate
marinates112516383marinates
marines93928013mari_nes
marranos1038423marranos
martians103111613martian_s
mediants11299493mediants
mordants1137143mordants
orients7311583_orients
ovarian1037643ovarian__
pageants1136693pageants
paints85921833pa_i_nts
parangs104314373par_angs
parents93418123par_ents
parfaits1346913parfaits
pariahs123812343paria_hs
parian83223963parian__
parings104219213pari_ngs
parlante1039693parlante
partans94418283partan_s
patients1088763patients
perianth1348553perianth
perianths1445473perianths
periapts1237273periapts
prints84320103_pri_nts
radians83013823radian_s
radiant82817133radiant_
rants55935343__r_ants
riant55833153__riant_
saints65122423sa_i_nts
salients839563salients
sapients1037423sapients
sarans64224433sar_an_s
sardanas937813sardanas
sarins63932623sari_n_s
sarments10311963sarments
saurians837763saurian_s
savants1038653sa_vants
servants1137993servants
spirants1088283spirants
sprints94113773spri_nts
taggants1044933taggants
taints64520533ta_i_nts
tarantas839193tar_antas
tarpans92513533tarpan_s
tartanas8258893tartanas
tartans72615823tartan_s
tarzans16329923tarzan_s
truants738163_truants
tyrants1037453tyr_ants
vacant11415133va_cant_
vaginas11298813vagi_nas
vaginate123911083vaginate
vagrant11410663vagrant_
vahines133410523vahi_nes
valerians1245343valerian_s
valiance1397383valiance
valiances1487203valiances
valiancy1674813valiancy
valiantly1544183valiantly
valines104520213vali_nes
varas86028193var_a__s
varia85824203varia___
variable13310063variable
variables1444673variables
variably1637433variably
variated121211393variated
varices123313573vari_ces
variers103712663vari_ers
varies94330873vari__es
variety1337743vari_ety
variolas1168533variolas
varioles11711123varioles
various103113103vari_ous
varlets10411573var_lets
varment12313243varment_
varmint12311683varmint_
varnas94212823var__nas
vaunts95212623va__unts
verdant11313293verdant_
verists103613673veri_sts
versant10313833versant_
vesicants1444753vesicants
viands1047813v__iands
vibrants1345913vibrants
vicariant1446463vicariant_
virions1039873virion_s
visitants1244763visitants
warrant10614243warrant_
warranty1465043warranty

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.763234195.3
2DLD Change Limit1461621676.75321644.0
3Display Results1671670.0602783.3
 (SQL Overall)1786911677.57623586.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.