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

180 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
terreen725757(None) 
terreens8246531terreens
terrene72411031terrene
jerreed1535212jerreed
regreen8309042regreen
terpene92310862terpene
terrae62915212terrae_
terrain7410852terrain
terrane72814232terrane
terrenes82212602terrenes
terret63425622terr_et
terrets72913582terrets
terrier73414962terrier
terries73425632terries
terrine72517572terrine
treen55622752t__reen
tureen63312722t_ureen
barren85317613barr_en
berried103714043berried
berries94423553berries
berseem1166463berseem
bescreen1244313bescreen
between1234693between
boreen8314313_boreen
careen84119493_careen
cerumen1147763cerumen
decree93117783decree_
decreed112710253decreed
decreer10269123decreer
decrees102513123decrees
degree82814853degree_
degreed10258883degreed
degrees92810723degrees
derries83124623derries
erred65915673_err_ed
evergreen1342253evergreen
ferrel92810203ferr_el
ferreled1234843ferreled
ferrels10248623ferrels
ferret93021173ferr_et
ferreted1236333ferreted
ferreter1136543ferreter
ferrets103111393ferrets
ferrety13287013ferrety
ferried113411523ferried
ferries103521083ferries
ferrymen1643943ferrymen
germen9612313ge_rmen
green65522143__green
hearken14338023hearken
hearten102411753hearten
herdmen13238453herdmen
herein93717793he_rein
hereon93914363he_reon
herried113514453herried
herries104025073herries
jereed144012073je_reed
jerreeds1653273jerreeds
jerries143817513jerries
kerogen1236093kerogen
kerries113317913kerries
mergee94018143mergee_
mergees104411233mergees
mermen10813813me_rmen
merrier92612303merrier
moreen8313343_moreen
overkeen15227103overkeen
overseen112612173overseen
overween14218513overween
peebeen1143903peebeen
pereon83517453pe_reon
perries93226603perries
perron83216623perr_on
preen75925053__preen
preteen939873preteen
rebreed104611073rebreed
regreens9257453regreens
regreet83015953regreet
rerisen73613643rerisen
rescreen1046703rescreen
reseen64318413re_seen
screen85216023_screen
serein63318463se_rein
serene63522353se_rene
serried82513963serried
serries73925353serries
sirree64017343sirree_
sirrees73410573sirrees
tarre55825633tarr_e_
tarred74720283tarr_ed
tarres64723043tarr_es
tarried83914133tarried
tarrier74323173tarrier
tarries73324263tarries
tarweed1137343tarweed
teared75722153tear_ed
tearer64822903tear_er
tearers75218233tearers
tearier73815613tearier
teen45938203t___een
teepee8314363teepee_
teepees939263teepees
tegmen988403te_gmen
tegumen10105423tegumen
telemen9310173telemen
teleran7510183teleran
tenrec837513tenr_ec
tenrecs936033tenrecs
tepee74724213te_pee_
tepees84215243te_pees
terce75721843te_rce_
tercel83612993te_rcel
tercelet1049883tercelet
tercels94110363tercels
terces83921413te_rces
tercet83624913te_rcet
tercets93512443tercets
terebene1045363terebene
teredo7310783te_redo
terete6319333te_rete
termed94816703te_rmed
termer85717253te_rmer
termers95414503termers
tern46134803te_r__n
terne56426153te_rne_
ternes65422903te_rnes
ternion739493ternion
terpenes102111573terpenes
terra54419663terr__a
terrace93311843terrace
terraced11318123terraced
terraces102712253terraces
terrains8410323terrains
terranes82514433terranes
terrapin1046203terrapin
terras63516973terr_as
terrases82111483terrases
terrella844703terrella
terrenely1243853terrenely
terreplein1251433terreplein
terriers84210823terriers
terrify1336353terrify
terrines82117553terrines
territ63421373terr_it
territs72714503territs
terror63811733terr_or
terrors73112213terrors
terry84721873terr__y
terse55026823te_rse_
tersely1038113tersely
terser67317823te_rser
tersest71713993tersest
tertian7511193tertian
terylene1144153terylene
testee64323303testee_
testees74215913testees
therein102310353therein
thereon10199263thereon
thirteen1143303thirteen
three87526913t_hree_
threep115910113t_hreep
threes97117323t_hrees
thriven13447023thriven
torrefy1353353torrefy
torrent7313413torrent
torten65314353t_orten
tree47745813t__ree_
treed65626733t__reed
treens65317873t__reens
trees55835763t__rees
triene64316383t_riene
tureens7289873t_ureens
turfmen1244163turfmen
turret63121853turr_et
turreted935373turreted
turrets73010673turrets
tween84413743t__ween
versemen1346853versemen
warren95012853warr_en
yestreen1144603yestreen

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.393454684.5
2DLD Change Limit1340271806.42020876.5
3Display Results1801800.0802250.0
 (SQL Overall)1786911806.89325923.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.