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

202 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
versant1031383(None) 
verdant11313291verdant
versants1137781versants
errant6618732_errant
jessant1438442jessant
oversalt11312742oversalt
peasant9314922peasant
persalt9315412persalt
servant10313622servant
variant10316802variant
versal93013752versa_l
verset94327322vers_et
versine102515172versine
versing112314192versing
verst84429372vers__t
aberrant1049543aberrant
aerosat7417183aerosa_t
arrant6623253_arrant
averment13311603averment
bezant17814543be_zant
bezzant1746893bezzant
brant74742173_br_ant
brisant9312683brisant
conversant1548213conversant
currant9314173currant
decant93524223de_cant
defiant11311923defiant
derat65044083der_a_t
desalt7518313de_salt
desand84812633de_sand
descant104315583descant
deviant11311313deviant
dormant102814373dormant
eluant6315093_eluant
errand758793_errand
errants7410643_errants
ersatz1536653_ersatz
erst47436433_ers__t
extant132714753_extant
ferment12315573ferment
fervent13310063fervent
formant123416003formant
gardant9314463gardant
gelant72821673ge_lant
gellant83214053gellant
gerent73223093ger_ent
german9611983german_
germane1049663germane
germans1079473germans
grant64840023_gr_ant
hereat93527413herea_t
inerrant8412483inerrant
iterant7317783iter_ant
jurant134216553jur_ant
leant56737783le__ant
levant9314493le_vant
meant76537213me__ant
mediant103516703mediant
merchant1548803merchant
merman10513863merman_
messan83912063messan_
messans92710463messans
mordant10312403mordant
obeisant1046083obeisant
operant9317223oper_ant
overact12315043over_act
overapt12312653over_apt
overcast132411973overcast
overeat102620323overea_t
overfast14249663overfast
overfat132712283overfa_t
overhand15229963overhand
overhang15248863overhang
overhunt14208663overhunt
overland122312003overland
overlent112715293overlent
overman12311463overman_
overmans13310313overmans
overmany1647143overmany
overpast132611023overpast
overplant142510713overplant
overran10311663overran_
overrank1548113overrank
oversad11259963oversa_d
oversale11313873oversale
oversalts1238163oversalts
oversave14310493oversave
oversaw13268163oversa_w
overset102821473overs_et
overshot1449433overshot
oversoft1438843oversoft
overspent1449923overspent
overtart11312493overtart
passant9813943passant
peasants1038263peasants
peccant13311733peccant
pedant9319493pe_dant
pendant10314853pendant
pennant9312493pennant
percent113520603percent
perianth1348553perianth
periapt11313413periapt
permeant12310913permeant
perpent112318803perpent
persalts1038193persalts
persist9315853persist
person83517873person_
persona92812453persona
persons93717013persons
pheasant1347083pheasant
pissant91012503pissant
pleasant1048323pleasant
present94022733present
pulsant9310563pulsant
pursuant1046563pursuant
rant45864683__r_ant
reboant9315093reboant
recant83228683re_cant
recreant10311283recreant
recusant1049463recusant
regnant8312843regnant
regrant8317323regrant
reliant7319243reliant
remnant9312633remnant
replant93318533replant
reptant92817073reptant
reran57329103rer_an_
rerent63832453rer_ent
resat55139683re_sa_t
resent63833623re_sent
revertant12128003revertant
riant55833153__riant
sealant73118303sealant
seawant103613413seawant
secant84023293se_cant
sejant133114483se_jant
sejeant1489723sejeant
sergeant9129403sergeant
serjeant1596473serjeant
serpent92916283serpent
serrano768463serrano
servants1137993servants
sextant142911963sextant
tenant6322473te_nant
terrane72814233terrane
tersest71713993tersest
truant6315783_truant
tyrant9315333tyr_ant
vacant11415133v_acant
vagrant11410663vagrant
valiant10314623valiant
variants1139203variants
varment12313243varment
varmint12311683varmint
vegan95114153ve_gan_
vegans103910853ve_gans
vegetant1246963vegetant
vent76049053ve___nt
vera76828843ver_a__
veranda1156323ver_anda
verbal112513663verba_l
verbals121910743verbals
verbena1235373verbena
verdancy1744723verdancy
verdantly1644333verdantly
verdict1339583verdict
verdin103113023verdin_
verdins112812333verdins
verging123812303verging
veriest103719133veriest
verist93823893ver_ist
vermian12329713vermian_
vermin113414523vermin_
vernal93514213verna_l
verse84723583vers__e
versed104515513vers_ed
verseman1345383verseman_
verser94516963vers_er
versers103813523versers
verses94223763vers_es
versets103913103versets
versify1636333versify
versines112213823versines
version10310923version
versions11310353versions
verso85314633vers__o
versos93812803vers_os
verste94515633vers_te
verstes104014283verstes
versts93914733vers_ts
versus94211143vers_us
vert77249373ver___t
vervain1335563vervain
vervains1435293vervains
vervet124619063ver_vet
vesicant1347493vesicant
vest75743603ve_s__t
vibrant12410393vibrant
volant9316323v_olant
warrant10614243warrant
weasand1135503weasand
wessand1144833wessand

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 Limit1340272025.98322401.3
3Display Results2022020.0762657.9
 (SQL Overall)1786912026.21528751.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.