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

134 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
versants113778(None) 
versant10313831versant_
errants7410642_errants
oversalts1238162oversalts
peasants1038262peasants
persalts1038192persalts
servants1137992servants
variants1139202variants
verdant11313292verdant_
versets103913102vers_ets
versines112213822versines
versts93914732vers__ts
aberrants1145853aberrants
aerosats8411013aerosa_ts
averments1449093averments
bezants1877343be_zants
bezzants1843643bezzants
brants85723053_br_ants
currants1037933currants
decants103514443de_cants
derats74625063der_a_ts
desalts839573de_salts
desands94810163de_sands
descants112910143descants
deviants1236733deviants
eluants737583_eluants
errands847603_errands
errant6618733_errant_
ersatz1536653_ersa_tz
ferments13311473ferments
formants13269953formants
gelants82611443ge_lants
gellants9308283gellants
gerents82612923ger_ents
germans1079473german_s
grants73722473_gr_ants
jessant1438443jessant_
jurants14379213jur_ants
levants1037723le_vants
mediants11299493mediants
merchants1646213merchants
messans92710463messan_s
mordants1137143mordants
operants1039483oper_ants
overacts1339653over_acts
overcasts14217853overcasts
overeats112415263overea_ts
overhands16227803overhands
overhangs16226553overhangs
overhunts15245743overhunts
overlands13218883overlands
overmans13310313overman_s
overplants15227333overplants
oversales12313143oversales
oversalt11312743oversalt_
oversaves15310183oversaves
oversets113114173overs_ets
overshots1546623overshots
peasant9314923peasant_
pedants10310113pe_dants
pendants1139093pendants
pennants1037063pennants
percents122713373percents
perianth1348553perianth
perianths1445473perianths
periapts1237273periapts
perpents122312033perpents
persalt9315413persalt_
persists1049183persists
personas102511883personas
persons93717013person_s
pheasants1443723pheasants
pissants1097363pissants
presents103315643presents
rants55935343__r_ants
recants93217093re_cants
recreants1146623recreants
recusants1145103recusants
regrants9310013regrants
remnants1036843remnants
replants102811243replants
rerents73319423rer_ents
resents74221223re_sents
revertants13124953revertants
sealants82610743sealants
seawants11337973seawants
secants93413893se_cants
sergeants10115593sergeants
serjeants1673963serjeants
serpents102410373serpents
serranos857873serranos
servant10313623servant_
sextants15287383sextants
tenants7311013te_nants
terranes82514433terranes
truants738163_truants
tyrants1037453tyr_ants
vagrants1246143vagrants
valiants1137793valiants
variant10316803variant_
varments1339063varments
varmints1335643varmints
vegans103910853ve_gan_s
vents86125933ve___nts
veranda1156323ver_anda
verandas1246233ver_andas
verbals121910743verba_ls
verbenas1345343verbenas
verdancy1744723verdancy
verdantly1644333verdantly
verdicts1446013verdicts
verdins112812333verdin_s
verists103613673ver_ists
versal93013753versa__l
versers103813523vers_ers
verses94223763vers__es
verset94327323vers_et_
versine102515173versin_e
versing112314193versin_g
versions11310353versions
versos93812803vers__os
verst84429373vers__t_
verste94515633vers__te
verstes104014283vers_tes
versus94211143vers__us
verts85724733ver___ts
vervains1435293vervains
vervets13419753ver_vets
vesicants1444753vesicants
vests85325983ve_s__ts
vibrants1345913vibrants
warrants1168503warrants
weasands1244563weasands
wessands1243673wessands

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.1531167915.0
2DLD Change Limit1461621346.97020970.2
3Display Results1341340.0632127.0
 (SQL Overall)1786911347.18624866.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.