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

119 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
terreens824653(None) 
terreen7257571terreen_
terrenes82212601terrenes
jerreeds1653272jerreeds
regreens9257452regreens
terpenes102111572terpenes
terrains8410322terrains
terranes82514432terranes
terrene72411032terr_ene
terrets72913582terr_ets
terriers84210822terriers
terries73425632terrie_s
terrines82117552terrines
treens65317872t__reens
tureens7289872t_ureens
barrens94414323barr_ens
berries94423553berrie_s
berseems1263933berseems
bescreens1343173bescreens
boreens9310403_boreens
careens94514703_careens
cerumens1235763cerumens
decreers11277623decreers
decrees102513123decree_s
degrees92810723degree_s
derries83124623derrie_s
evergreens1451723evergreens
ferrels10248623ferr_els
ferreous1146033ferreous
ferreters1246253ferreters
ferrets103111393ferr_ets
ferries103521083ferrie_s
germens1078633ge_rmens
greens75716873__greens
hearkens15336693hearkens
heartens113010153heartens
herries104025073herrie_s
jereeds15326393je_reeds
jerreed1535213jerree_d
jerries143817513jerrie_s
kerogens1345763kerogens
kerries113317913kerrie_s
mergees104411233mergee_s
moreens939963_moreens
overweens15247003overweens
peebeens1243063peebeens
pereons92815003pe_reons
perries93226603perrie_s
perrons93115483perr_ons
preens85020113__preens
preteens1038123preteens
rebreeds11426003rebreeds
regreen8309043regreen_
regreets9287853regreets
rescreens1144863rescreens
screens95212183_screens
sereins73716123se_reins
serenes73222903se_renes
serries73925353serrie_s
sirrees73410573sirree_s
tarres64723043tarr_e_s
tarriers83411713tarriers
tarries73324263tarrie_s
tarweeds1244273tarweeds
tearers75218233tear_ers
tearless848713tearless
teens56227483t___eens
teepees939263teepee_s
telerans859473telerans
tenrecs936033tenr_ecs
tepees84215243te_pee_s
tercelets1144813tercelets
tercels94110363te_rcels
terces83921413te_rce_s
tercets93512443te_rcets
terebene1045363terebene
terebenes1146063terebenes
teredos839183te_redos
termers95414503te_rmers
termless1036233termless
ternes65422903te_rne_s
ternions838813ternions
terns55226873te_r__ns
terpene92310863te_rpene
terraces102712253terraces
terrae62915213terrae__
terrain7410853terrain_
terrane72814233terr_ane
terrapins1146183terrapins
terras63516973terr__as
terrases82111483terrases
terrella844703terrella
terrellas944293terrellas
terrenely1243853terrenely
terrepleins1351473terrepleins
terret63425623terr_e_t
terrier73414963terrie_r
terrine72517573terr_ine
territs72714503terr_its
terrors73112213terr_ors
terseness948403terseness
tertians839103tertians
terylene1144153terylene
terylenes1244933terylenes
testees74215913testee_s
thirteens1243003thirteens
threeps12687043t_hreeps
threes97117323t_hree_s
torrent7313413torr_ent
torrents838143torrents
treen55622753t__reen_
trees55835763t__ree_s
trienes74118413t_rienes
triens65417543t__riens
tureen63312723t_ureen_
turrets73010673turr_ets
tweens9489843t__weens
warrens103810893warr_ens
yestreens1243533yestreens

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.423422437.4
2DLD Change Limit1461621196.62622058.9
3Display Results1191190.0462587.0
 (SQL Overall)1786911197.09525185.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.