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

248 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
regreet8301595(None) 
regreen8309041regreen
regreets9287851regreets
regret73723531regr_et
degree82814852degree_
degreed10258882degreed
degrees92810722degrees
egret63327312_egr_et
greet65835322__greet
rebreed104611072rebreed
reerect92915882reerect
regent74127672reg_ent
reglet73724232reg_let
regraft11310152regraft
regrant8317322regrant
regrate82618662regrate
regreens9257452regreens
regreeted1136172regreeted
regress82711452regress
regrets83212922regrets
regrew10388562regr_ew
remeet86325472re_meet
rerent63832452re_rent
retreat7317532retreat
afreet9315153_afreet
agree65226033_agree_
agreed84712503_agreed
agrees74915323_agrees
aigret73720023aigr_et
befret11315963befr_et
beget85632563beg__et
bereft114317303be_reft
beret74946363be_r_et
bigfeet1376153bigfeet
cermet10321153ce_rmet
dearest83618673dearest
decree93117783decree_
decreed112710253decreed
decreer10269123decreer
decrees102513123decrees
egest65222343_eg_est
egress73310433_egress
egrets72712243_egrets
erect74129333_e_rect
ferret93021173fe_rret
gerent73223103ge_rent
gleet65532343__gleet
great66034243__great
gree56641563__gree_
greed75125693__greed
greegree1044483greegree_
greegrees1142853greegrees
greek105915943__greek
green65522143__green
grees65132473__grees
greets75117423__greets
hereat93527413he_reat
jereed144012073je_reed
jerreed1535213jerreed
leveret103014003leveret
merest84725113me_rest
mergee94018143mergee_
mergees104411233mergees
nearest73415843nearest
neglect1047363neglect
preerect1259273preerect
premeet11615153pre_meet
pretreat10311923pretreat
pugree92112473pugree_
pugrees10218523pugrees
ragee65432663rag_ee_
ragees74618663rag_ees
raggee84217603raggee_
raggees93710913raggees
ragweed1235073ragweed
rarest65725483r_arest
reagent8716603reagent
realest73322433realest
reared75930013rear_ed
rearer64928913rear_er
rearers74323563rearers
rearmed103912823rearmed
rearrest8311603rearrest
reblent9614253reblent
rebred95816353rebr_ed
rebreeds11426003rebreeds
recarpet12310603recarpet
recent83630853re_cent
recept103319073re_cept
recheat12415933recheat
recrate92621663recrate
recreant10311283recreant
recreate10313603recreate
recrement13411363recrement
recruit939773recruit
reddest9311953reddest
redeem9311533re_deem
redirect11147993redirect
redraft11310573redraft
redream10107913redream
redreamt11127183redreamt
redress82511873redress
redrew10309513redr_ew
redried93714893redried
redries83721713redries
redroot8312903redroot
reeject16349623reeject
reelect911515633reelect
reerects10319923reerects
reest54938093re__est
refect114319333re_fect
refeed104717623re_feed
refeel93913243re_feel
refelt94521423re_felt
referee101615753referee
refereed12149693refereed
referees111310413referees
referent112813423referent
reflect123913713reflect
reflet94024233re_flet
reforest1139963reforest
refract121311603refract
refreeze2063263refreeze
refresh1335453refresh
refried113513873refried
refries104419733refries
refront10313263refront
regale74821453regale_
regaled93615963regaled
regaler83814623regaler
regales83520793regales
regarded11279803regarded
regave104713383regave_
regear73512743reg_ear
regents83416543reg_ents
reges65628793reg__es
reggae858953reggae_
reggaes948883reggaes
regilt71217493reg_ilt
regime95313943regime_
regimen104411573regimen
regiment114414053regiment
regimes104514743regimes
regive104814323regive_
regiven11478323regiven
regives115014213regives
reglets83512983reglets
reglue739703reglue_
reglued936333reglued
reglues838713reglues
regnant8312843regnant
regorge9257833regorge_
regorged11227333regorged
regorges10238413regorges
regrade92612033regrade
regraded113410763regraded
regrades103212173regrades
regrafts1235303regrafts
regrants9310013regrants
regrated102816333regrated
regrates92618403regrates
regreened1145553regreened
regreeting1237343regreeting
regressed1138113regressed
regresses10310463regresses
regretted1137233regretted
regretter1045973regretter
regrind938983regrind
regroom1077303regroom
regroup1095173regroup
regrow10309883regr_ow
regrown11237363regrown
regrows11269153regrows
regrowth1544033regrowth
reheat94423943re_heat
reheel93610823re_heel
reject154116283re_ject
relent64431853re_lent
relet54749823re__let
remarket142111033remarket
remeets93712413re_meets
remelt85123123re_melt
remet74843723re__met
renest64529713re_nest
rennet64624853re_nnet
reorder8239483reorder
reorient8613473reorient
repeat85127213re_peat
repent84728873re_pent
replete92912993replete
represent11410073represent
repress92712683repress
reprint9318983reprint
request16311023request
reread71715433re_read
rerents73319423re_rents
rerepeat1047953re_repeat
rescreen1046703rescreen
reseat64131493re_seat
resect84424703re_sect
resee54336333re_see_
reseed74823293re_seed
reseek103813133re_seek
reseen64318413re_seen
resees63827483re_sees
resent63833623re_sent
reset55051863re__set
resmelt9411773resmelt
resojet14312823resojet
respect11412033respect
respelt9312143respelt
retarget9312743retarget
retest64028453re_test
retiree75019083retiree_
retirees84611653retirees
retract91318113retract
retread849003retread
retreats8311413retreats
retried84419153retried
retries74129073retries
revere94621253revere_
revered112819333revered
reverent112615093reverent
reverer103815833reverer
reveres103621343reveres
revert93529113re_vert
revest94623603re_vest
revet84938843re__vet
rewet85135153re__wet
rewrapt12138113rewrapt
rewrite10311143rewrite
rewrote1039123rewrote
rogered939553rogered
searest73322023searest
secret8325063secr_et
secrete9311073secrete
segment10312563segment
serest64831613se_rest
street64125773_street
tercet83624913te_rcet
terete6319333te_rete
terreen7257573terreen
terret63425623te_rret
vegete1039483veg_ete
verset94327323ve_rset
vervet124619063ve_rvet
webfeet1544593webfeet
wergelt1138583wergelt

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 Limit1340272486.98619185.1
3Display Results2482480.0932666.7
 (SQL Overall)1786912487.48523873.2
 
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.