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

237 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
variant1031680(None) 
valiant10314621valiant
variants1139201variants
arrant6623252_arrant
covariant1447862covariant
gardant9314462gardant
hariana10310242hariana
invariant1266812invariant
lariat6629042laria_t
ovarian1037642ovarian_
parian83223962parian_
parians93519732parians
radiant82817132radiant
riant55833152__riant
vacant11415132va_cant
vagrant11410662vagrant
valiants1137792valiants
varia85824202varia__
variance1397412variance
varias95019902varia_s
variate101316432variate
varment12313242varment
varmint12311682varmint
verdant11313292verdant
versant10313832versant
vicariant1446462vicariant
warrant10614242warrant
affiant1348433affiant
alant55742293_a_lant
apian75018333_apian_
arcana8912583_arcana
arcane81216743_arcane
ardent73022613_ardent
argent74023663_argent
arhat8327093_arha_t
aria46245423_aria__
ariary94114203_ariary
arias55438023_aria_s
aright103817663_aright
aroint6328153_aroint
aroynt9312893_aroynt
arpent84822093_arpent
askant10412713_askant
aslant6317753_aslant
avant86224663_a_vant
avian84616053_avian_
avians93711563_avians
banian8315383banian_
banians9312033banians
baring95135853bari_ng
barman103519703barman_
biriani945643biriani
brant74742173_br_ant
brisant9312683_brisant
callant94121223callant
carat75048793car_a_t
carcanet12316343carcanet
carina84325323cari_na
carinae94318583carinae
carinal94318223carinal
carinas93622383carinas
carinate103320243carinate
caring95137993cari_ng
carman103920743carman_
currant9314173currant
damiana1046563damiana
daring84928683dari_ng
defiant11311923defiant
deviant11311313deviant
dormant102814373dormant
durian7312003durian_
durians839573durians
earing75235483eari_ng
errant6618733_errant
evacuant1344413evacuant
fabricant1644893fabricant
faint85837063fa_i_nt
farina94618233fari_na
farinas103215233farinas
faring105231283fari_ng
forint9325023fori_nt
formant123416003formant
galivant1247083galivant
gallant83517113gallant
garland948703garland
garment10315233garment
giant65430593__giant
grant64840023_gr_ant
guardant1046443guardant
habitant1348673habitant
haint85436323ha_i_nt
harianas1139163harianas
haricot12311963haricot
harijan1735783harijan_
harijans1845723harijans
haring104233003hari_ng
invariants1374083invariants
irritant847693irritant
jarina134014063jari_na
jarinas143712183jarinas
jurant134216553jur_ant
kalian10312163kalian_
kalians11310183kalians
karat96837593kar_a_t
lariats7615053lariats
larine63927043lari_ne
magian9312833magian_
magians10310753magians
maranta9311693mar_anta
margent10316693margent
maria75032883maria__
marina84623413mari_na
marinas93519373marinas
marinate103017783marinate
marine84230403mari_ne
marrano939423marrano
martian93514683martian_
martians103111613martians
mediant103516703mediant
mordant10312403mordant
narial6317953naria_l
narine63422553nari_ne
natant6318733na_tant
oaring74225303oari_ng
orient6322533_orient
ovarial1037613ovaria_l
pageant10312783pageant
paint75443693pa_i_nt
parang93715513par_ang
parent83230423par_ent
parfait12312053parfait
pariah114320583paria_h
pariahs123812343pariahs
paring94236493pari_ng
parlante1039683parlante
partan83820563partan_
partans94418283partans
passant9813943passant
patient9617073patient
perianth1348553perianth
periapt11313413periapt
pliant83918823_pliant
print74837463_pri_nt
radian74117273radian_
radians83013823radians
radiants9259443radiants
rampant11312173rampant
rant45864673__r_ant
raring74332873rari_ng
reliant7319243reliant
saint55147073sa_i_nt
salient7419763salient
saltant7316773saltant
sapient9415333sapient
saran53730303sar_an_
sarans64224433sar_ans
sardana838643sardana
sarin55239253sari_n_
sarins63932623sari_ns
sarment9318763sarment
saurian739913saurian_
saurians837763saurians
savant9416043sa_vant
servant10313623servant
spirant9814293spirant
sprint84526793spri_nt
taggant9310213taggant
taint55542283ta_i_nt
taring73932283tari_ng
tarpan82814293tarpan_
tarpans92513533tarpans
tartan64217513tartan_
tartana73010193tartana
tartans72615823tartans
tarzan152910753tarzan_
tarzans16329923tarzans
truant6315783_truant
tyrant9315333tyr_ant
vacillant1444713vacillant
vagina102710933vagi_na
vaginae11377683vaginae
vaginal11288403vaginal
vaginas11298813vaginas
vaginate123911083vaginate
vagrants1246143vagrants
vahine123612113vahi_ne
vain75233003va_i_n_
valerian1147123valerian_
valerians1245343valerians
valiance1397383valiance
valiancy1674813valiancy
valiantly1544183valiantly
valine94623093vali_ne
vanman1139793vanman_
vara75530883var_a__
varas86028193var_a_s
variable13310063variable
variably1637433variably
variances14117363variances
variated121211393variated
variates111214973variates
variating13310933variating
varices123313573varices
varied104817863vari_ed
varier94619353vari_er
variers103712663variers
varies94330873vari_es
variety1337743variety
variola1068893variola
variole10711593variole
various103113103various
varix154313503vari__x
varlet9423503var_let
varments1339063varments
varmints1335643varmints
varna84516173var__na
varnas94212823varna_s
varying1429723varying
vaunt85925313va__unt
veriest103719133veriest
verist93823893veri_st
vermian12329713vermian_
versants1137783versants
vesicant1347493vesicant
viand9511073v__iand
vibrant12410393vibrant
vicariants1543733vicariants
vigilant1246423vigilant
virion9310683virion_
virions1039873virions
visitant1147363visitant
volant9316323v_olant
volitant1147863volitant
wariest105122503wariest
waring105029443wari_ng
warrants1168503warrants
warranty1465043warranty

Search took 10 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 Limit1340272378.92315020.4
3Display Results2372370.0932548.4
 (SQL Overall)1786912379.17219482.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.