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 “verse” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

152 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
verse8472358(None) 
averse95811181averse
perse75429521perse
terse55026821terse
verge93419841verge
versed104515521versed
verser94516961verser
verses94223761verses
verset94327321verset
verso85314631verso
verst84429371verst
verste94515631verste
verve115417721verve
adverse1145952adverse
aerie54634602aerie
arse46539272_arse
avers85127312avers_
berme96022942berme
birse74517402birse
burse75527252burse
carse74934332carse
cease75227652cease
cense75121402cense
cere66741472cer_e
ceres75540012ceres
cerise84822042cerise
ceruse83914522ceruse
corse75036182corse
curse75829142curse
dense65923502dense
dere56845902der_e
diverse11429992diverse
ease45042332_ease
eerie55228532eerie
else45923082_else
erase54925492_erase
ere36352772_er_e
erne46727432_erne
erose55727282_erose
ers36046282_ers_
erses55826802_erses
erst47436432_erst
fease84824872fease
fere76342232fer_e
feres86038182feres
fesse86116332fesse
geese64316002geese
gorse65926812gorse
hearse94114282hearse
here76447102her_e
heres86245902heres
hers75844872hers_
horse86132652horse
inverse10249642inverse
jersey1636332jersey
jesse126012832jesse
kerne94718222kerne
kersey1336792kersey
lease55230262lease
lense54523432lense
marse76231152marse
mense75025632mense
merde84320122merde
mere67244442mer_e
meres75143572meres
merge84523692merge
merle75824372merle
morse76032702morse
nerve86617372nerve
nurse54420122nurse
obverse1234752obverse
overs85224792overs_
oversea102412112oversea
oversee102717602oversee
overset102821472overset
oversew132810832oversew
overuse10310922overuse
parse75236992parse
pease75231112pease
peise75825772peise
pere66450262per_e
peres76246642peres
perses85428062perses
peruse84016842peruse
prese75228382prese
purse76028892purse
rerise64325632rerise
rerose63320852rerose
reuse56025362reuse
reverse103913742reverse
seise54727852seise
sense55526822sense
sere46153472ser_e
seres55448892seres
serge64727472serge
sers45746652sers_
serve85425962serve
tease55428712tease
tense55225842tense
terce75721842terce
terne56426152terne
terser67317822terser
torse55833332torse
valse85117522valse
vars75742072vars_
varve115716852varve
vase75629652v_ase
vee65750182ve__e
veers84521362veers_
vees75439432vees_
veges94118872veges
vegie94614512vegie
venae85920982venae
venge95117992venge
venose9310842venose
venue84918212venue
vera76828842ver_a
verb96224872ver_b
verbose1237752verbose
verbs104614392verbs
verged114815162verged
verger104315702verger
verges104320182verges
verier94620962verier
verism113214262verism
verist93823892verist
verite94323442verite
vermes115019142vermes
versal93013752versal
versers103813522versers
versets103913102versets
versine102515172versine
versos93812802versos
verstes104014282verstes
versts93914732versts
versus94211142versus
vert77249372ver_t
vertex1637372vertex
verts85724732verts
vertu85017612vertu
verves124617882verves
vervet124619062vervet
very108025642ver_y
vessel937952vessel
vest75743602ve_st
vets76835092vets_
vexes155719122vexes
viers85621952viers_
vires84529682vires
vise75632682v_ise
were76238332wer_e
worse86525262worse

Search took 2 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 Filter178691538000.313570897.8
2DLD Change Limit538001521.56334421.0
3Display Results1521520.0305066.7
 (SQL Overall)1786911521.90693751.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.