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

177 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
terse5502682(None) 
perse75429521perse
tease55428711tease
tense55225841tense
terce75721841terce
terne56426151terne
terser67317821terser
torse55833331torse
verse84723581verse
aerie54634602aerie
arse46539272_arse
averse95811182averse
berme96022942berme
birse74517402birse
burse75527252burse
carse74934332carse
cease75227652cease
cense75121402cense
cere66741472cer_e
ceres75540012ceres
cerise84822042cerise
ceruse83914522ceruse
corse75036182corse
curse75829142curse
dense65923502dense
dere56845902der_e
ease45042332_ease
eerie55228532eerie
else45923082_else
erase54925492_erase
ere36352772_er_e
erne46727422_erne
erose55727272_erose
ers36046282_ers_
erses55826802_erses
erst47436432_erst
eterne6311722eterne
fease84824872fease
fere76342232fer_e
feres86038182feres
fesse86116332fesse
geese64316002geese
gorse65926812gorse
hearse94114272hearse
here76447102her_e
heres86245902heres
hers75844872hers_
horse86132652horse
jersey1636332jersey
jesse126012832jesse
kerne94718212kerne
kersey1336782kersey
lease55230262lease
lense54523432lense
marse76231152marse
mense75025632mense
merde84320122merde
mere67244442mer_e
meres75143572meres
merge84523682merge
merle75824372merle
morse76032702morse
nerve86617372nerve
nurse54420122nurse
parse75236992parse
pease75231112pease
peise75825772peise
pere66450262per_e
peres76246642peres
perses85428062perses
peruse84016842peruse
prese75228382prese
purse76028892purse
rerise64325632rerise
rerose63320842rerose
reuse56025362reuse
seise54727852seise
sense55526822sense
sere46153472ser_e
seres55448892seres
serge64727462serge
sers45746652sers_
serve85425962serve
stere55328542ster_e
steres63929532steres
tare45957622tar_e
tares57456562tares
targe65227092targe
tarre55825632tarre
tars46763952tars_
tarsi55222172tarsi
tasse54821842tasse
tawse85616502tawse
tears55436462tears_
teas45851492teas_
teased74721152teased
teasel63914982teasel
teaser65421522teaser
teases65426272teases
teds54932572teds_
tee38366872te__e
tees45353582tees_
tegs56031492tegs_
telae54323292telae
tele45040872te_le
teles54536002teles
tels46841692tels_
tenge65720432tenge
tens45647412tens_
tensed74817832tensed
tenser64919432tenser
tenses64722552tenses
tepee74724212tepee
terai53525482terai
tercel83612992tercel
terces83921412terces
tercet83624912tercet
terete6319332terete
terga63315642terga
term66233152ter_m
termed94816702termed
termer85717252termer
terms75523472terms
tern46134802ter_n
ternes65422902ternes
terns55226872terns
terra54419652terra
terrae62915202terrae
terret63425622terret
terry84721872terry
tersely1038102tersely
tersest71713992tersest
test48651622te_st
tets45847452tets_
tews76431642tews_
there87527392ther_e
theres96525472theres
therme115814992therme
these86519012these
those85218142those
three87526912three
throe89321422throe
thyrse1235132thyrse
tierce8339842tierce
tiers55526522tiers_
tire46143352tir_e
tires55437492tires
tore47359322tor_e
tores55352672tores
torose64317692torose
tors46157382tors_
torses64727952torses
torsi57423362torsi
torsk94915772torsk
torso56922142torso
torte55431702torte
touse55430672touse
tree47745812t_ree
trees55835762trees
tres46542902tres_
tress55423162tress
true46725852t_rue
tsetse664692tsetse
tyers86220052tyers_
tyre75428252tyr_e
tyres84725232tyres
verge93419832verge
versed104515512versed
verser94516962verser
verses94223762verses
verset94327322verset
verso85314632verso
verst84429372verst
verste94515632verste
verve115417722verve
were76238332wer_e
worse86525262worse

Search took 3 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.0931921408.6
2DLD Change Limit538001771.93627789.3
3Display Results1771770.0463847.8
 (SQL Overall)1786911772.07586116.1
 
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.