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

207 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
regreen830904(None) 
regreens9257451regreens
regreet83015951regreet
degree82814852degree_
degreed10258882degreed
degrees92810722degrees
green65522142__green
rebreed104611072rebreed
regimen104411572regimen
regiven11478322regiven
regreened1145552regreened
regreets9287852regreets
regress82711452regress
regret73723532regr_et
regrets83212922regrets
regrew10388562regr_ew
regrown11237362regrown
rescreen1046702rescreen
reseen64318412re_seen
terreen7257572terreen
agree65226033_agree_
agreed84712503_agreed
agrees74915323_agrees
begroan1036103begroan
bescreen1244313bescreen
between1234693between
boreen8314313_boreen
careen84119493_careen
decree93117783decree_
decreed112710263decreed
decreer10269123decreer
decrees102513123decrees
egress73310433_egress
egret63327313_egr_et
egrets72712243_egrets
evergreen1342253evergreen
germen9612313ge_rmen
gree56641563__gree_
greed75125693__greed
greegree1044493greegree_
greegrees1142853greegrees
greek105915943__greek
greens75716873__greens
greeny104811453__greeny
grees65132473__grees
greet65835323__greet
hearken14338033hearken
hearten102411763hearten
hegumen1355463hegumen
herein93717793he_rein
hereon93914363he_reon
jereed144012073je_reed
jerreed1535213jerreed
legmen939343leg_men
mergee94018143mergee_
mergees104411233mergees
mermen10813813me_rmen
moreen8313343_moreen
nongreen945513nongreen
peebeen1143903peebeen
pereon83517453pe_reon
preen75925053__preen
prescreen1345103prescreen
preteen939873pre_teen
pugree92112473pugree_
pugrees10218523pugrees
ragee65432663rag_ee_
ragees74618663rag_ees
raggee84217603raggee_
raggees93710913raggees
ragmen93712183rag_men
ragweed1235073ragweed
ratteen7329113ratteen
reared75930013rear_ed
rearer64928913rear_er
rearers74323563rearers
rearmed103912823rearmed
rebred95816353rebr_ed
rebreeds11426003rebreeds
reclean938523reclean
recreant10311283recreant
recrement13411363recrement
recrown12257573recrown
redden83613623re_dden
redeem9311533re_deem
redrawn11245953redrawn
redream10107913redream
redress82511873redress
redrew10309513redr_ew
redried93714903redried
redries83721713redries
redriven12226153redriven
reedmen1038333reedmen
reerect92915883reerect
refeed104717623re_feed
refeel93913243re_feel
referee101615753referee
refereed12149693refereed
referees111310413referees
referent112813423referent
refrain10310043refrain
refreeze2063263refreeze
refresh1335453refresh
refreshen1585163refreshen
refried113513883refried
refries104419733refries
refrozen2063873refrozen
regain74517763reg_ain
regale74821453regale_
regaled93615963regaled
regaler83814623regaler
regales83520793regales
regarded11279803regarded
regave104713383regave_
regear73512743reg_ear
regent74127673reg_ent
reges65628793reg__es
reggae858953reggae_
reggaes948883reggaes
regime95313943regime_
regimens11469233regimens
regiment114414053regiment
regimes104514743regimes
region74614903reg_ion
regive104814323regive_
regives115014213regives
reglet73724233reg_let
reglets83512983reglets
reglue739703reglue_
reglued936333reglued
reglues838713reglues
regorge9257833regorge_
regorged11227333regorged
regorges10238413regorges
regrade92612033regrade
regraded113410763regraded
regrades103212173regrades
regraft11310153regraft
regrant8317323regrant
regrate82618663regrate
regrated102816333regrated
regrates92618403regrates
regreening1246033regreening
regreeted1136173regreeted
regreeting1237343regreeting
regressed1138123regressed
regresses10310463regresses
regretted1137233regretted
regretter1045973regretter
regrind938983regrind
regroom1077303regroom
reground1045073reground
regroup1095173regroup
regrow10309883regr_ow
regrows11269153regrows
reharden1276303reharden
reheel93610823re_heel
remeet86325473re_meet
reopen8311573re_open
reorder8239483reorder
reorient8613473reorient
reprehend1584073reprehend
represent11410073represent
repress92712683repress
reran57329103re_r_an
reread71715433re_read
rerent63832453re_rent
rerisen73613643rerisen
rerun58722153re_r_un
rescreens1144863rescreens
resee54336333re_see_
reseed74823293re_seed
reseek103813133re_seek
resees63827483re_sees
resewn9459813re_sewn
retaken113911803retaken
retene69224273re_tene
retiree75019083retiree_
retirees84611653retirees
retrain7615423retrain
retread849003retread
retreat7317533retreat
retried84419163retried
retries74129073retries
revere94621253revere_
revered112819333revered
reverend12288853reverend
reverent112615093reverent
reverer103815833reverer
reveres103621343reveres
rewaken144410273rewaken
rewiden1137533rewiden
rewoken145112293rewoken
rewoven13557933rewoven
rogered939553rogered
screen85216023_screen
serein63318463se_rein
serene63522353se_rene
shagreen1243443shagreen
tegmen988403teg_men
tegumen10105423tegumen
terreens8246533terreens
terrene72411033terrene
treen55622753__treen
tureen63312723_tureen
yeggmen1442673yeggmen
yestreen1144603yestreen

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 Filter1786911340270.406440125.6
2DLD Change Limit1340272076.53320515.4
3Display Results2072070.0902300.0
 (SQL Overall)1786912077.02925422.0
 
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.